Average Issues

[oconnodale]

Hi,
I am trying to get an average of the values of every second cell in a range along a single row.
Some of the cells in the range will be blank and I don't want those cells included in the average total or divisor.
However some of the cells will have 0 in them. I do want these cells included in the average total and divisor.
So far I am using the formula:
=AVERAGE(IF(MOD(COLUMN(E15:M15)-COLUMN(E15),2)=0,IF(E15:M15>0,E15:M15))) with a CTRL+SHIFT+ENTER.
Unfortunately this does not work the way I want it to. If one of the cells that is relevant to this formula has a 0 in it the formula still does not include it meaning the average divisor is one short.
Is there a way around this so that any cell with value 0 in it is included in the calculation?
Appreciate your help.

 

[Aladin Akyurek]

Hi,
I am trying to get an average of the values of every second cell in a range along a single row.
Some of the cells in the range will be blank and I don't want those cells included in the average total or divisor.
However some of the cells will have 0 in them. I do want these cells included in the average total and divisor.
So far I am using the formula:
=AVERAGE(IF(MOD(COLUMN(E15:M15)-COLUMN(E15),2)=0,IF(E15:M15>0,E15:M15))) with a CTRL+SHIFT+ENTER.
Unfortunately this does not work the way I want it to. If one of the cells that is relevant to this formula has a 0 in it the formula still does not include it meaning the average divisor is one short.
Is there a way around this so that any cell with value 0 in it is included in the calculation?
Appreciate your help.

Control+shift+enter:

=AVERAGE(IF(MOD(COLUMN(E15:M15)-COLUMN(E15),2)=0,IF(ISNUMBER(E15:M15),E15:M15)))