Simple Average Question
On Mar 9, 5:39*pm, Ron Rosenfeld wrote:
On Fri, 9 Mar 2012 16:22:13 -0800 (PST), Blake wrote:
How do I average the following column:
1
2
3
4
5
6
The blank row after the three should also be counted as zero. *However
I have a very large spreadsheet, and I don't want to go back and enter
zeros in all of the blank cells.
Is there a way?
Thanks
=sum(a1:a7)/rows(a1:a7)
This one I like the best. Thanks to all who responded.
|