Maybe this is what you had in mind...

=IF(E4=0,"",IF(COUNT(S4:X4),AVERAGE(S4:X4),""))

--
Biff
Microsoft Excel MVP


"Earl1704" wrote in message
...
=Average(If(E4=0,"",S4:X4))
The answer always returns 0.00 even though data to be averaged are in
cells.
Tried several varations but to no avail
I need to get rid of #DIV/0! and leave cells blank or 0.00 (If no values
yet)
Prefer blank cells
Some sells may stay blank for years others change monthly, there are
hundreds of #DIV/0! which makes it hard to see values which are important.
Thanks for any help.......... Earl