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