Clarification

BY J. CARLTON COLLINS

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:

 

 Find us on Facebook      Follow us on Twitter

 

SPONSORED REPORT

CPEOs provide peace of mind around payroll services

The creation of these new IRS-certified service providers for small businesses clarifies some issues around traditional professional employer organizations.

QUIZ

Pronoun practice to help polish your prose

Using pronouns correctly in writing and speech can help you make a good impression. Try our 10-question quiz.