Counting number of cells filled in for several columns

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

Microsoft ExcelMicrosoft Office

Last Comment

Roy Cox

8/22/2022 - Mon

ASKER CERTIFIED SOLUTION

Brian B

10/15/2018

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

GET A PERSONALIZED SOLUTION

Ask your own question & get feedback from real experts

Find out why thousands trust the EE community with their toughest problems.

SOLUTION

Roy Cox

10/15/2018

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

GET A PERSONALIZED SOLUTION

Ask your own question & get feedback from real experts

Find out why thousands trust the EE community with their toughest problems.

Brian B

10/15/2018

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

Fordraiders

10/21/2018

ASKER

Thanks

Roy Cox

10/21/2018

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

This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.

Certified Expert Program

Credly Partnership

Udemy Partnership