Sum if formula using "left" or "find" for range

[bensko]

Not sure how to sum column I when the first three letters in column B are "ISP" using the following:

=SUM(IF('QUOTE STATUS'!$M$3:$M$5000>=AP1,IF('QUOTE STATUS'!$M$3:$M$5000,<AP2,IF(FIND("ISP",'QUOTE STATUS'!$B3:$B$5000),IF('QUOTE STATUS'!$G$3:$G$5000="W",'QUOTE STATUS'!$I$3:$I$5000,"")))))

AP1 & AP2 are a date range in column M
"W" = order won in column G

Thanks for your help in advance...!

Ben

 

[Scott Huish]

=sumproduct(--('quote status'!$m$3:$m$5000>=ap1),--(left('quote status'!$b$3:$b$5000,3)="isp"),--('quote status'!$g$3:$g$5000="w"),'quote status'!$i$3:$i$5000)

 

[bensko]

Thanks HotPepper,

got it to work with my application...

Ben