#DIV/0!

[Richard]

=SUM(A1,B1,C1)/COUNT(A1,B1,C1)How would you keep this error #DIV/0! from
showing up when nothing is in a cell. Thanks in advance!

 

[Max]

One of these would be options:
=IF(COUNT(A1:C1)=0,"",SUM(A1:C1)/COUNT(A1:C1))
=IF(COUNT(A1:C1)=0,"",AVERAGE(A1:C1))

 

[T. Valko]

Try this:

=IF(COUNT(A1:C1),AVERAGE(A1:C1),"")

 

[muddan madhu]

try this

=IF(ISERROR(SUM(A1:C1)/COUNT(A1:C1)),"",SUM(A1:C1)/COUNT(A1:C1))

 

[Mike H]

Hi,

Why are you making averages complicated, use this

=IF(ISERROR(AVERAGE(A1:C1)),"",AVERAGE(A1:C1))


Mike

 

[T. Valko]

P.S.

If there might be 3 0s in the range you'll still get the error.

Or, if there might be a situation like this you'll still get the error:

A1 = 10
B1 = -10
C1 = 0

For a generic "catch-all" see Mike's suggestion.

 

[Dave Peterson]

I don't think you really meant this warning.

P.S.

If there might be 3 0s in the range you'll still get the error.

Or, if there might be a situation like this you'll still get the error:

A1 = 10
B1 = -10
C1 = 0

For a generic "catch-all" see Mike's suggestion.

 

[Mike H]

If there might be 3 0s in the range you'll still get the error.

or perhaps not

 

[T. Valko]

I don't think you really meant this warning.

You are correct. I didn't mean that at all! <g>

Time for a break.