sum product
 

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

sum product
 

=SUMPRODUCT(--(D$2:D$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" wrote in
message ...

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

sum product
 

jst what i needed thanks


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