Average formula where blank cells are counted as zeros
=AVERAGE(IF($A$2:$A$6<0,$A$2:$A$6)) AND HIT Ctrl+Shift+Enter to enter the
array formula.
"krwelling" wrote:
I am trying to write an average formula that takes into account the blank
cells.
I had only cells A2, A4, A6 filled out, but when I do =average(A1:A6), it is
not treating the blanks as zeros so the answer is much higher than it should
be.
Should I do a logic formula within the cells?
|