1. column
  2. 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

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:

 

Find us on Facebook | Follow us on Twitter