Average for non-consecutive cells excluding zeros (even when they all contain zeros)

Hello,

i'm trying to get an average # for non-consecutive cells excluding zeros.
It works just fine, except when the cell range contains ALL zeros, in which case I get a DIV/0 error as a result (Instead of a zero that I would like to get). In every other case it works just fine.
How can I modify the above formula to work either way, i.e. when some of the cell range values are zeros AND when ALL of the cell range values are zeros...?

=AVERAGE(IF(E4,E4,{""}),IF(G4,G4,{""}),IF(I4,I4,{""}),IF(K4,K4,{""}),IF(M4,M4,{""}))

Thanks in advance.

That't it.

Thanks a lot.

Hi
I know this thread is solved, would this save all the IFS.

Formula:

Please Login or Register  to view this content.