leave cell blank and continue with formula

[hlpme]

#Animals Total Pounds
1062 70.90 75,300
1063 69.36 73,734
1063 71.08 75,556
1066 68.89 73,439
1064 69.27 73,704
1069 70.29 75,143
1073 70.83 75,997
1075 70.59 75,881
1081 67.82 73,316
1083 69.69 75,474
1068 71.64 76,516
0 ?????
0 ?????

22353 #DIV/0! 1,352,243
721.1 #DIV/0! 75124.61111


Each day, I add the numbers of animals and lbs in the spreadsheet. Is it
possible to get the bottom to average even when all cells are not filled in?
When I get to the end of the month the 31st and 30th might not have data
depending on the month, so I am looking to skip those cells when no data is
entered.

Any help?

 

[JE McGimpsey]

If you use

=AVERAGE(B2:B32)

and

=AVERAGE(C2:C32)

blanks will be ignored.

 

[Gaurav]

If you want to ignore zeros....

(AVERAGE(IF(C2:C32<>0,C2:C32,"")))

 

[Gaurav]

Press CTRL+SHIFT+ENTER. not just ENTER and this formula requires all the
cells to be filled. If you have no data, enter a 0 in that cell.

 

[Gaurav]

Well...I just tried and it works even if you leave some cells blank. Dont
forget to array enter it...CTRL+SHIFT+ENTER.