#div/0 error

[Earl1704]

=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

 

[new1]

=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

new1@[no/spam]realce.net

 

[T. Valko]

Maybe this is what you had in mind...

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