Hi all,
Having trouble finding an answer to what I assume is an easy question. I'm trying to find a formula (that will auto fill) for a continuing average. consider the below table
What formula do I need in C3 to calculate the average of B2+B3 so I can auto fill for the remaining of C, where C4 = (B2+B3+B4)/3, C5 = (B2+B3+B4+B5)/4, C6 = (B2+B3+B4+B5+B6)/5, etc etc
I understand this can be done the long way, calculating each cell, but lets just assume C has over 1500 rows.
Thanks in advance
Having trouble finding an answer to what I assume is an easy question. I'm trying to find a formula (that will auto fill) for a continuing average. consider the below table
What formula do I need in C3 to calculate the average of B2+B3 so I can auto fill for the remaining of C, where C4 = (B2+B3+B4)/3, C5 = (B2+B3+B4+B5)/4, C6 = (B2+B3+B4+B5+B6)/5, etc etc
I understand this can be done the long way, calculating each cell, but lets just assume C has over 1500 rows.
Thanks in advance