# leave cell blank and continue with formula

H

#### 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?

J

#### JE McGimpsey

If you use

=AVERAGE(B2:B32)

and

=AVERAGE(C2:C32)

blanks will be ignored.

G

#### Gaurav

If you want to ignore zeros....

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

G

#### 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.

G

#### Gaurav

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