Thursday, March 28, 2013

Excel count cells

In a formula, how to get the count of cells in a range:

COUNTA([range])

If you want the count on non-blank cells, use this:

COUNT([range])

A reference:

http://www.dummies.com/how-to/content/counting-cells-in-excel-2010-with-count-counta-and.html