Counting the number of fields in a column that have data?

[Rick]

I have an Excel document with about 5,300 rows. One of the columns has
data entered only into some of the fields, maybe 100 of the 5,300 rows.

Is there an easy way to get Excel to count all of the fields in that
column that have data entered in it?

Thanks!

 

[Bob Greenblatt]

I have an Excel document with about 5,300 rows. One of the columns has
data entered only into some of the fields, maybe 100 of the 5,300 rows.

Is there an easy way to get Excel to count all of the fields in that
column that have data entered in it?

Thanks!

Sure, just use COUNTA.

 

[Rick]

I have no idea how to use that formula. Is there an easy way to apply it
similar to the way that autosum works?

Thanks!!!

 

[a_whlr]

I have the same question. I don't quite understand the answer. Could you explain what COUNTA is?

 

[CyberTaz]

Have a look in Excel Help - surprising what you may find there

In the meantime, the only required argument for COUNTA is the range of cells
to be counted just like the SUM function, such as;

=COUNTA(B1:B5300)

The difference is that COUNTA counts the number of cells that aren't blank
rather than summing values.

HTH |:>)
Bob Jones
[MVP] Office:Mac