problem with an averaging formula

[Bobbie]

I'm trying to write a formula that will average each column A,B and C but if
there isn't any numbers in the column leave the total blank instead of having
the #DIV/0! show up. The formula I have used to get the totals is
=average(B3:B6). The values in the total row get used on another formula on a
different worksheet and the #DIV/0! messes up that formula. Thanks

A B C

33.3 0.0
66.7 50.0
-100.0 -66.7
75.0
Total 18.8 #DIV/0! -5.6

 

[Dave Peterson]

=if(count(b3:b6)=0,"",average(b3:b6))

(Check for some numbers in that range first.)

 

[Bobbie]

Dave,

It seems to do the trick. Thank You!

=if(count(b3:b6)=0,"",average(b3:b6))

(Check for some numbers in that range first.)