| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I set up an IF formula with multiple qualifiers?
I want to see how many people attended an event and then attribute it to that
specific sales person. In the raw data, the attended column is Y or N and there is a column for the assigned sales guy. Here is my code that is not working: =SUM(IF((AND(F:F="Tommy Wheeler",'2007 regs '!G:G="Y")),1,0)) This output should tell me how many people registered within Tommy's sales territory. Any help would be appreciated! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| COUNTIF with additional qualifiers? | Excel Worksheet Functions | |||
| How do I use 3 separate column qualifiers to sum? IF statements? | Excel Worksheet Functions | |||
| Minimum qualifiers to Find (VBA) the actual last used Row, Column | Excel Discussion (Misc queries) | |||
| Table lookup using multiple qualifiers | Excel Discussion (Misc queries) | |||
| Saving as a csv file with text qualifiers | Excel Discussion (Misc queries) | |||
Threaded Mode
