Counting number of cells filled in for several columns

Fordraiders
Fordraiders used Ask the Experts™
on
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

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
EE Topic Advisor, Independant Technology Professional
Commented:
Sure

=countif(<cell range>,"<>''")

Edit for clarity, the second part with a space between each character: , " < > ' ' " ), i.e. quote, less than, greater than, apostrophe, apostrophe, quote.

This formula will count anything entered in the cell range, even if it's not the correct data type. However you can customize this formula if you want more conditions. If that isn't what you are looking for, please provide a sample of data and the value you are expecting.
Roy CoxGroup Finance Manager
Commented:
You can use the COUNTA Function to hoe many cells are not empty in a given range

=COUNTA(C2:C10,D2:D10,E2:E11)

For a more detailed explanation

COUNTA function
Brian BEE Topic Advisor, Independant Technology Professional

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

Author

Commented:
Thanks
Roy CoxGroup Finance Manager

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

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial