The number that is calculated is correct if I do not use (--(TCS!$E$2:$E
$1000="GDS"). Do I have the brackets in the right place?


=IF(SUMPRODUCT(--(TCS!$E$2:$E$1000="GDS"),--(TCS!$Z$2:$Z$1000=H2),--(TCS!$AA
$2:$AA$1000<""))<0,SUMPRODUCT(--(TCS!$Z$2:$Z$1000=H2),--(TCS!$AA$2:$AA
$1000<"")),"")

Thanks

Sharon

--
Message posted via http://www.officekb.com