A Better Idea

BY STANLEY ZAROWIN

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")

 

More from the JofA:

 

 Find us on Facebook      Follow us on Twitter

 

SPONSORED QUIZ

How well do you know small business?

There are over 30 million small businesses in the U.S., and many of them are optimistic in their outlook. Are you familiar with the obstacles and opportunities they are facing? Test your small business acumen with this quiz sponsored by Chase Ink®.

SPONSORED REPORT

In focus: Payroll

Providing payroll services that comply with ever-changing regulations and meet evolving employee and employer demands is no easy task. Paychex's Tom Hammond discusses common payroll considerations for CPA firms.