counting dropdown list with multiple text selections

R

Robin

What if I have a data validated drop down list is cell C7 that with in the
list the choices are Billy, Bobby, Cindy, Mike, and Randy.
There can be one picked from this list over a 1000 sheets within cell C7.
What is the formula to notate on an end sheet for the number of times each
on the the selections of the list were selected in cell C7 with the
corresponding cell C-7(not included in the 1000 selection for the number of
times each on the the selections of the list were selected.
Billy selected 100
Bobby selected 200,
Cindy selected 100
Mike selected 400
Randy selected 200
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Move Chart with Text 0
produce list automatically from choice of drop down list 1
Calculate per minute cost of cell phone usage 1
Help with a Dropdown List of Times 2
Summing Contiguous Values in a Column? 6
Importing text with text qualifier 1
Validated list - how to make conditional 1
Determining Quantity and Keeping a Constant 4

Top