| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Drop Down Total Function
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Drop Down Total Function
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 On Oct 12, 11:16*pm, kj0601 wrote: 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| HOW TO USE OF SUMIF FUNCTION TO SUM TOTAL NO OF PQ1, PQ2, OTQ OF . | Excel Worksheet Functions | |||
| using an IF function for a total | Excel Discussion (Misc queries) | |||
| Using an IF function for a total | Excel Worksheet Functions | |||
| Formula to total items from a drop list with values in several col | Excel Discussion (Misc queries) | |||
| How do I total a column which was created using the MID function? | Excel Worksheet Functions | |||
Linear Mode
