B
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
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