Find Number of Populated Cells in an Excel Column

I have an excel spreadsheet that is constantly being updated and I need a formula for determining the number of entries in each column.  Again, I would much prefer a formula rather than a macro.  I don't need to know any values, just the number of populated cells in a column.  Note that there are no null cells in the column so essentially I just need to know the index of the last cell (minus 1 for the header).

Thanks!
Bob SchneiderCo-OwnerAsked:
Who is Participating?
 
NorieVBA ExpertCommented:
Bob

You can use COUNTA to count the no of non-empty cells in a column, subtract 1 to exclude the header.

=COUNTA(A:A)-1
0
 
Rob HensonFinance AnalystCommented:
That would be a simple count then.

There are a number of different count formulas:

=COUNT(Range)   gives count of numeric values
=COUNTA(Range)   gives count of non-blank items

I would suggest you use:

=COUNTA(A:A)-1     where A:A is the column being counted. The -1 allows for the header.
0
 
Roy CoxGroup Finance ManagerCommented:
I also, use Conditional Formatting to highlight empty cells if it is essential that all are completed
0
 
Bob SchneiderCo-OwnerAuthor Commented:
Thanks everyone!
0
 
Roy CoxGroup Finance ManagerCommented:
Pleased to help
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.