problem with an averaging formula
 

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

problem with an averaging formula
 

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

(Check for some numbers in that range first.)

Bobbie wrote:

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

problem with an averaging formula
 

Dave,

It seems to do the trick. Thank You!

"Dave Peterson" wrote:

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

(Check for some numbers in that range first.)

Bobbie wrote:

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