=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