Hi all,

Im trying to get th below to work

Im trying to count the rows where column DU is equal to FR3 and column
ER isnt one of the two char combo's


=SUMPRODUCT((DU$2:DU$2530=FR3),(ER$2:ER$2530<{"EX ","FI","FP","FT","GA","HO"
,"IT","NP","CF","PI","PP","PY","SI","WA","AP","BP" ,"BR","CF","DB","DC","DI",
"DO","DP","DS","ES","AG","LN","HS","HC","RI","SB", "RN","CQ","CS"}))

Please help as i cant get it to work


--
ceemo
------------------------------------------------------------------------
ceemo's Profile: http://www.excelforum.com/member.php...o&userid=10650
View this thread: http://www.excelforum.com/showthread...hreadid=520539