sum product

[ceemo]

Hi all,

Im trying to get th below to work

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


=SUMPRODUCT((DU$2U$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 wor

 

[Bob Phillips]

=SUMPRODUCT(--(D$2$25=F3),
--(NOT(ISNUMBER(MATCH(E$2:E$25,{"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"},0)))))

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

 

[ceemo]

jst what i needed thanks