| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sumif 2 text conditions
In column A I have employee names, in coolumn B I have country names, and in
column C, I have department. I want to do a sumif for example that would count how many people in the United States are in the Sales department. I've tried an array formula something like this, but it's not working, {sum(if(and(b2:b100="United States",c2:c100="Sales"),1,0))} Any ideas? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sumif with multiple conditions | Excel Worksheet Functions | |||
| Sumif with 2 conditions | Excel Discussion (Misc queries) | |||
| SUMIF with two conditions? | Excel Worksheet Functions | |||
| SUMIF with 2 conditions | Excel Worksheet Functions | |||
| Read Text File into Excel Using VBA | Excel Discussion (Misc queries) | |||
Threaded Mode
