#div/0 error
 

=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

#div/0 error
 

On 8 mar, 23:49, Earl1704 wrote:
=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

Good evening

Maybe the data to be averaged is not considered as numeric (are there
quotes ? Or cells are text formated ?)

Hope it helps

#div/0 error
 

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