- column
- TECHNOLOGY Q&A
Clarification
BY J. CARLTON COLLINS
Please note: This item is from our archives and was published in 2011. It is provided for historical reference. The content may be out of date and links may no longer function.
Related
November 10, 2026
What Binance’s $6.3B crypto hack means for CPAs
November 1, 2026
Why AI needs to show its work
November 1, 2026
How firms make AI adoption work for them
TOPICS
Christopher Breslin, a CPA in Louisville, Ky., spotted an important caveat that we neglected to mention in a recent “Better Idea” item (“Technology Q&A,” JofA, Nov. 2010, page 70), which suggested ways of averaging noncontiguous cells in Excel that contain some zero values. The two methods suggested would average all positive values in the specified range, but would ignore negatives (and zeroes). To include negative numbers in the average, change the criterion in either method from “>0” to “<>0″.
More from the JofA:
