M
Mr. X
My apologies if this is a repeat post. I'm having news reader
problems.
I was given this formula for averaging the last five numbers in a
column of numbers:
=AVERAGE(OFFSET(A2,COUNTA(A:A)-5,0,5,1))
It works fine unless there are some blank cells like below:
1. 3
2.
3.
4. 6
5. 7
6. 8
7.
8. 35
9.
10. 11
Is there a way to change it so that it will average the last five
numbers in this column and ignore the blank cells?
Thanks for your help.
Frank
problems.
I was given this formula for averaging the last five numbers in a
column of numbers:
=AVERAGE(OFFSET(A2,COUNTA(A:A)-5,0,5,1))
It works fine unless there are some blank cells like below:
1. 3
2.
3.
4. 6
5. 7
6. 8
7.
8. 35
9.
10. 11
Is there a way to change it so that it will average the last five
numbers in this column and ignore the blank cells?
Thanks for your help.
Frank