CHD's Memory
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
Newer Post
Older Post
Home