We help IT Professionals succeed at work.

How Would I Count Different Entries From A Single Excel 2010 Spreadsheet Column

Lord_Dragon asked
Last Modified: 2014-09-18
I have an Excel 2010 Spreadsheet that is used for capturing survey data. I have one column in this spreadsheet that has a dropdown menu with three options (Delete, Migrate, Save).

So every cell in that column has one of those three options in it.

I want to be able to count each one of those options seperately from the other two throughout the length of the column.

Any instuction on how to do this would be greatly appreciated.
Watch Question

This one is on us!
(Get your first solution completely free - no credit card required)


The semi colon behind the range needs to be a comma but otherwise its just what I needed. Much thanks.


I've requested that this question be closed as follows:

Accepted answer: 0 points for Lord_Dragon's comment #a40074686

for the following reason:

Works like a charm, thank you.


Thank you

Gain unlimited access to on-demand training courses with an Experts Exchange subscription.

Get Access
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Empower Your Career
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.


Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.