Another approach would be to enter zeros in all the blank cells...
Select the data
Use Edit | Go To | Special | Blanks
Enter a 0
Hold down the Ctrl key and press Enter.
--
Jim Cone
Portland, Oregon USA
http://www.contextures.com/excel-sort-addin.html
Editorial review of Special Sort Excel add-in (30 ways to sort)





"Blake"
wrote in message
...
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