Adding up dropdown menu categories.

J

JCD

I created a dropdown list in my worksheet and I was wondering if there was
any way to add up how many times each individual item was selected. Any help
would be appreciated.

Thanks!
 
T

T. Valko

Does that mean you have more than 1 drop down list?

If so, make a list of the unique items from the drop down lists then use a
formula like this:

...........A...................B...
1...Unique list ..... Count
2...Item1.......................
3...Item2.......................
4...Item3.......................

Assume the drop down lists are in the range J1:J10

Enter this formula in B2:

=COUNTIF(J$1:J$10,A2)

Copy down as needed.
 
Top