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

Cybersecurity threats proliferating for midsize and smaller businesses

This report details how SMBs can properly protect private information from breaches, design and implement a cybersecurity policy, and create safeguards for training and education.

QUIZ

News quiz: Senate health care bill in the spotlight

Reports related to the Republican bill to repeal many provisions of the PPACA, other tax issues, and the giant AICPA ENGAGE Conference offered a diverse reading list for June. See how much you know about recent news with this short quiz.