call us today: 1.800.876.8376
email us: info@synergy.com
Calculating statistics by storing the starting and ending rows in columns, you can use a formula like:

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

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.


Mark as helpful.
0

Posted in: Formula Entry: Advanced formulas