There is no easy way. You would be better off doing your own average - use
the sum and countif formulas. Create a column that has the difference
between each of the pairs. Then do a sum of that column and divide by the
countif for that column (COUNTIF {range},"0").

"Gizmo" wrote:

Excel2003
I have a page containing this formula in Column GF:
=AVERAGE((BD4-BE4),(BH4-BI4),(BL4-BM4))
How can I check each range for 0 before performing the calculation?

If any of the cells contain 0, I want to exclude it from the average.

ex:
BD4 =4,BE4 =2,BH4 =4,BI4 =2,BL4 =4,BM4 =2
Average = 2
If any of these cells = 0, remove it and its accompanying cell from the
Average formula.
BD4 =4,BE4 =2,BH4 =0,BI4 =2,BL4 =4,BM4 =2
Average = 2