Link to home
Start Free TrialLog in
Avatar of James Halliburton
James HalliburtonFlag for United States of America

asked on

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

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.
ASKER CERTIFIED SOLUTION
Avatar of Pavel Celba
Pavel Celba
Flag of Czechia 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
Avatar of James Halliburton

ASKER

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