We help IT Professionals succeed at work.

Counting number of cells filled in for several columns

56 Views
Last Modified: 2018-10-21
excel 2010
windows 10

I have a workbook with a worksheet with several columns   A-I   WITH HEADERS

What I need:
Is there a way to count the number of cells filled in for each column and give me a total ?

Thanks
fordraiders
Comment
Watch Question

EE Topic Advisor, Independent Technology Professional
CERTIFIED EXPERT
Commented:
This problem has been solved!
(Unlock this solution with a 7-day Free Trial)
UNLOCK SOLUTION
Roy CoxGroup Finance Manager
CERTIFIED EXPERT
Commented:
This problem has been solved!
(Unlock this solution with a 7-day Free Trial)
UNLOCK SOLUTION
Brian BEE Topic Advisor, Independent Technology Professional
CERTIFIED EXPERT

Commented:
That's what I love about Excel, many ways to do the same thing.

Author

Commented:
Thanks
Roy CoxGroup Finance Manager
CERTIFIED EXPERT

Commented:
Pleased to help. COUNTA has the advantage of allowing several non-contiguous ranges to be added.