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.