Count Non Blank in column

Diane Alsing · Feb 9, 2005

I would like to count from A12:A1000 how many cells are NOT blank. What
function can I use for this?

Thank you.

JE McGimpsey · Feb 9, 2005

One way:

=COUNTA(A12:A1000)

Diane Alsing · Feb 9, 2005

Yup - thanks!

JE McGimpsey said:
One way:

=COUNTA(A12:A1000)

Art · Sep 16, 2005

thanks for the formula.

Diane Alsing said:
Yup - thanks!