How do I calculate statistics by storing the starting and ending rows to be evaluated in columns?

To calculate statistics by storing the starting and ending rows in columns, you can use a formula like:

c3=mean([c0:c1, 2:2])

The starting row numbers would be entered in column 0 and the ending row numbers would be in column 1.

Keep in mind that as the function moves down the data window, each row becomes row 0 when it is being evaluated, so you would need to adjust the starting and ending rows that are entered in the input columns to get the correct results.

Scroll to Top