View Single Post
  #1   Report Post  
azazel
 
Posts: n/a
Default 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