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.