=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