Multiple SUMIF Criteria

[azazel]

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???

 

[Bob Phillips]

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]

no that didnt wor

 

[Guest]

=sumif([your first criteria here "KYLE"])+SUMIF([2ND CRITERIA])+.....