F
Frank West
Hi,
Someone gave me this formula to average the most recent five items in
a column of numbers:
=AVERAGE(OFFSET(B2,COUNTA(A:A)-5,0,5,1))
It works great unless the list has blank cells. In that case it does
not work.
1. 6
2.
3. 7
4. 9
5.
6. 2
7.
8. 1
9. 23
10 4
How can I make it work when the columns have some blank cells?
Thanks,
Frank
Someone gave me this formula to average the most recent five items in
a column of numbers:
=AVERAGE(OFFSET(B2,COUNTA(A:A)-5,0,5,1))
It works great unless the list has blank cells. In that case it does
not work.
1. 6
2.
3. 7
4. 9
5.
6. 2
7.
8. 1
9. 23
10 4
How can I make it work when the columns have some blank cells?
Thanks,
Frank