Link to home
Start Free TrialLog in
Avatar of Tocogroup
TocogroupFlag for United Kingdom of Great Britain and Northern Ireland

asked on

How do I count the number of cells in an Excel table column ?

Hi Experts,
Is there an Excel function for counting the number of cells in a table column ?
Or is the only alternative adding COUNTA to COUNTBLANK results ?
Thanks
Toco
ASKER CERTIFIED SOLUTION
Avatar of Steve
Steve
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
=ROWS(<your range here>)

If you need to count the number of cells in across rows and columns, then use this:

=ROWS(<your range>) * COLUMNS(<your range>)
doh! (note to self: work more on quick twitch muscle groups)
Avatar of Tocogroup

ASKER

Thank you both.
Sorry Mark, I must accept the first correct solution.
Regards
Toco
No worries - that is perfectly appropriate.  Glad you got what you needed.