I don't think you really meant this warning.

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

Time for a break.


--
Biff
Microsoft Excel MVP


"Dave Peterson" wrote in message
...
I don't think you really meant this warning.

"T. Valko" wrote:

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.

--
Biff
Microsoft Excel MVP

"T. Valko" wrote in message
...
Try this:

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

--
Biff
Microsoft Excel MVP


"Richard" wrote in message
...
=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!



--

Dave Peterson