| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Multiple SUMIF Criteria
How do i add another Criteria to a SUMIF formula??? I want it to SUMIF the criteria equals "KYLE" and "CARTMAN" and "STAN" and "KENNY". This is the formula... SUMIF('[Ex Supporting Docs 10-31-05.xls]Brokerage Assets UM'!$B:$B,"*KYLE*",'[Ex Supporting Docs 10-31-05.xls]Brokerage Assets UM'!$F:$F) How do I add more names to that formula??? -- azazel ------------------------------------------------------------------------ azazel's Profile: http://www.excelforum.com/member.php...o&userid=28250 View this thread: http://www.excelforum.com/showthread...hreadid=483712 |
|
#2
|
|||
|
|||
|
Multiple SUMIF Criteria
Untested, but try this
=SUMPRODUCT(--(ISNUMBER(FIND({"KYLE","CARTMAN","STAN","KENNY"},'[Ex Supporting Docs 10-31-05.xls]Brokerage AssetsUM'!$B1:$B1000))),'[Ex Supporting Docs 10-31-05.xls]Brokerage Assets UM'!$F1:$F1000) -- HTH RP (remove nothere from the email address if mailing direct) "azazel" wrote in message ... How do i add another Criteria to a SUMIF formula??? I want it to SUMIF the criteria equals "KYLE" and "CARTMAN" and "STAN" and "KENNY". This is the formula... SUMIF('[Ex Supporting Docs 10-31-05.xls]Brokerage Assets UM'!$B:$B,"*KYLE*",'[Ex Supporting Docs 10-31-05.xls]Brokerage Assets UM'!$F:$F) How do I add more names to that formula??? -- azazel ------------------------------------------------------------------------ azazel's Profile: http://www.excelforum.com/member.php...o&userid=28250 View this thread: http://www.excelforum.com/showthread...hreadid=483712 |
|
#3
|
|||
|
|||
|
Multiple SUMIF Criteria
no that didnt work -- azazel ------------------------------------------------------------------------ azazel's Profile: http://www.excelforum.com/member.php...o&userid=28250 View this thread: http://www.excelforum.com/showthread...hreadid=483712 |
|
#4
|
|||
|
|||
|
Multiple SUMIF Criteria
=sumif([your first criteria here "KYLE"])+SUMIF([2ND CRITERIA])+.....
"azazel" wrote: How do i add another Criteria to a SUMIF formula??? I want it to SUMIF the criteria equals "KYLE" and "CARTMAN" and "STAN" and "KENNY". This is the formula... SUMIF('[Ex Supporting Docs 10-31-05.xls]Brokerage Assets UM'!$B:$B,"*KYLE*",'[Ex Supporting Docs 10-31-05.xls]Brokerage Assets UM'!$F:$F) How do I add more names to that formula??? -- azazel ------------------------------------------------------------------------ azazel's Profile: http://www.excelforum.com/member.php...o&userid=28250 View this thread: http://www.excelforum.com/showthread...hreadid=483712 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I use the sumif if I have multiple criteria (i.e. greater . | Excel Worksheet Functions | |||
| Multiple Criteria in a SUMIF formula | Excel Discussion (Misc queries) | |||
| SUMIF, multiple criteria | Excel Discussion (Misc queries) | |||
| How do I sum (like sumif) but predicated on multiple criteria, in. | Excel Worksheet Functions | |||
| How do I ask for multiple criteria when creating a "sumif" formul. | Excel Worksheet Functions | |||
Linear Mode
