ExcelBanter - Count Non Blank in column

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Count Non Blank in column (https://www.excelbanter.com/excel-discussion-misc-queries/12297-count-non-blank-column.html)

Diane Alsing

Count Non Blank in column

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

One way:

=COUNTA(A12:A1000)

In article ,
Diane Alsing wrote:

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

Diane Alsing

Yup - thanks!

"JE McGimpsey" wrote:

One way:

=COUNTA(A12:A1000)

In article ,
Diane Alsing wrote:

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

Art

thanks for the formula.

"Diane Alsing" wrote:

Yup - thanks!

"JE McGimpsey" wrote:

One way:

=COUNTA(A12:A1000)

In article ,
Diane Alsing wrote:

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

All times are GMT +1. The time now is 06:08 AM.