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

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

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

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