Adding up dropdown menu categories.
 

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!

Adding up dropdown menu categories.
 

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.

--
Biff
Microsoft Excel MVP


"JCD" wrote in message
...
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!