Drop Down Total Function

  • Thread starter Thread starter kj0601
  • Start date Start date
K

kj0601

I have created a drop down menu & would like to total the responses by fruit.
For example, i have the drop down options being:
apple
orange
banana
peach
I would like a total number of each fruit chosen. I think this is a vlookup
formula, but i am cross-eyed trying to find this simple formula!
thanks.
 
Assuming your drop-down is in A1, and that your fruits are listed in
column C, you could put this in B1:

=COUNTIF(C:C,A1)

Hope this helps.

Pete
 

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

Macro-delete & move heading 2
How to determine the number of types? 5
How to get a drop down menu to return another value 1
How can I attach data to a validation drop-down box? 2
how to count the number of times text occurs based on condition 3
Merging 800 Excel files 1
Limiting choices 1
Index/match across multiple columns? 19

Back
Top