software

I can find the average omitting 0 values with an array formula if
numbers are in a contiguous row or column:

=AVERAGE(IF(A2:A7lt;gt;0, A2:A7,quot;quot;))

BUT

what if my cells to average are A2, D2, G2, J2, M2, etc (every 3
colums) and i don't want to include 0 values?

Thanks,

jrozendaalTry...

=AVERAGE(IF(MOD(COLUMN(A2:M2)-COLUMN(A2) 0,3)=0,IF(A2:M2gt;0,A2:M2)))

....confirmed with CONTROL SHIFT ENTER, not just ENTER. Adjust the range
accordingly.

Hope this helps!

In article .comgt;,
quot;jrozendaalquot; gt; wrote:

gt; I can find the average omitting 0 values with an array formula if
gt; numbers are in a contiguous row or column:
gt;
gt; =AVERAGE(IF(A2:A7lt;gt;0, A2:A7,quot;quot;))
gt;
gt; BUT
gt;
gt; what if my cells to average are A2, D2, G2, J2, M2, etc (every 3
gt; colums) and i don't want to include 0 values?
gt;
gt; Thanks,
gt;
gt; jrozendaal