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).

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

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

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.
Roy CoxGroup Finance ManagerCommented:
I also, use Conditional Formatting to highlight empty cells if it is essential that all are completed
Bob SchneiderCo-OwnerAuthor Commented:
Thanks everyone!
Roy CoxGroup Finance ManagerCommented:
Pleased to help
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.