| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to Sum Up sales data by a product category from anther sheet | Excel Worksheet Functions | |||
| Counting Rows/Columns for Copying Formulas | Excel Discussion (Misc queries) | |||
| Percentages | Charts and Charting in Excel | |||
| How to set a formula to count the product appear how manytime | Excel Worksheet Functions | |||
| Which function(s)? | Excel Worksheet Functions | |||
Linear Mode
