#div/0 error

E

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
 
N

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

T. Valko

Maybe this is what you had in mind...

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

#DIV/0! error 1
#DIV/0 error 2
#DIV/0! 1
#DIV/0! message 1
Find Average w/ #DIV/0! in Cell 5
getting rid of a #Div/0! error 2
DIV/0 error 5
how to average a range of cells and ignore #div/0! answer 4

Top