A Better Idea
An item in the August issue, “Averaging noncontiguous cells that contain some zero values” (page 73), generated several ideas from readers for a better way to address the problem. David M. Fogel, a CPA in Roseville, Calif., was the first to suggest this formula, noting it could be used in a large spreadsheet over a wide range of cells:
=SUM(A1:G1)/COUNTIF(A1:G1,”>0″)
Shane Eloe, a CPA at Dickinson & Clark CPAs in Council Bluffs, Iowa, posted an even shorter option on the JofA’s Facebook page:
=AVERAGEIF(A1:G1,”>0″)
Advertisement
More from the JofA:
