Count cells

L

lhkittle

In a worksheet, how can I get a count of all cells that are NOT empty?
Click to expand...

Put count in the Help search window and you will get a ton of info.

Meanwhile:

=COUNTA(A1:A10)

Regards,
Howard
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SUM / COUNT formula 3
Count Values in a Range, Not Formulas 2
Problems with count, counta and countifs 3
Is there a way to count colored cells that are conditionally formatted? 3
Count cells if next column has text 2
Complicated Formula Problem 10
Conditional Format top/mid/bottom 33% of cells, but ignoring blank cells 0
Count of Font Format 1

Top