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
Showing posts with label count cells. Show all posts
Showing posts with label count cells. Show all posts
Thursday, March 28, 2013
Excel count cells
In a formula, how to get the count of cells in a range:
If you want the count on non-blank cells, use this:
A reference:
http://www.dummies.com/how-to/content/counting-cells-in-excel-2010-with-count-counta-and.html
If you want the count on non-blank cells, use this:
A reference:
http://www.dummies.com/how-to/content/counting-cells-in-excel-2010-with-count-counta-and.html
Subscribe to:
Posts (Atom)