| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to create the formula for that attached explanation
Hi Professionals,
I have 2 columns of raw data, column A (code), colum B (nest). Could you help me to write a formula that will count the quantity that meets both criterias which the code and nest stated? Code Nest Qty 9000 CBRNM1 ?? 9000 CBLNM1 ?? 3002 CBRNM1 ?? 3002 CBLNM1 ?? 3001 CBRNM1 ?? 3001 CBLNM1 ?? Raw datas :- Code Nest 9000 CBRNM1 9000 CBLNM1 9000 CBRNM1 9000 CBRNM1 9000 CBLNM2 9000 CBRNM2 9000 CBLNM1 9000 CBLNM1 9000 CBLNM1 3002 CBLNM1 3002 CBRNM1 3002 CBLNM1 3002 CBLNM1 3002 CBLNM1 3002 CBRNM1 3002 CBLNM1 3002 CBRNM1 3001 CBRNM1 3001 CBRNM1 3001 CBRNM1 3001 CBRNM1 3001 CBRNM1 3001 CBRNM1 3001 CBLNM1 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
how to create the formula for that attached explanation
=SUMPRODUCT(--($A$2:$A$200=9000),--($B$2:$B$200="CBRNM1"))
of course you can put the test values in cells and compare against those. -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "ddiicc" wrote in message ... Hi Professionals, I have 2 columns of raw data, column A (code), colum B (nest). Could you help me to write a formula that will count the quantity that meets both criterias which the code and nest stated? Code Nest Qty 9000 CBRNM1 ?? 9000 CBLNM1 ?? 3002 CBRNM1 ?? 3002 CBLNM1 ?? 3001 CBRNM1 ?? 3001 CBLNM1 ?? Raw datas :- Code Nest 9000 CBRNM1 9000 CBLNM1 9000 CBRNM1 9000 CBRNM1 9000 CBLNM2 9000 CBRNM2 9000 CBLNM1 9000 CBLNM1 9000 CBLNM1 3002 CBLNM1 3002 CBRNM1 3002 CBLNM1 3002 CBLNM1 3002 CBLNM1 3002 CBRNM1 3002 CBLNM1 3002 CBRNM1 3001 CBRNM1 3001 CBRNM1 3001 CBRNM1 3001 CBRNM1 3001 CBRNM1 3001 CBRNM1 3001 CBLNM1 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
how to create the formula for that attached explanation
Many Thanks Bob and your prompt reply
"Bob Phillips" wrote: =SUMPRODUCT(--($A$2:$A$200=9000),--($B$2:$B$200="CBRNM1")) of course you can put the test values in cells and compare against those. -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "ddiicc" wrote in message ... Hi Professionals, I have 2 columns of raw data, column A (code), colum B (nest). Could you help me to write a formula that will count the quantity that meets both criterias which the code and nest stated? Code Nest Qty 9000 CBRNM1 ?? 9000 CBLNM1 ?? 3002 CBRNM1 ?? 3002 CBLNM1 ?? 3001 CBRNM1 ?? 3001 CBLNM1 ?? Raw datas :- Code Nest 9000 CBRNM1 9000 CBLNM1 9000 CBRNM1 9000 CBRNM1 9000 CBLNM2 9000 CBRNM2 9000 CBLNM1 9000 CBLNM1 9000 CBLNM1 3002 CBLNM1 3002 CBRNM1 3002 CBLNM1 3002 CBLNM1 3002 CBLNM1 3002 CBRNM1 3002 CBLNM1 3002 CBRNM1 3001 CBRNM1 3001 CBRNM1 3001 CBRNM1 3001 CBRNM1 3001 CBRNM1 3001 CBRNM1 3001 CBLNM1 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| formula explanation | Excel Discussion (Misc queries) | |||
| Would like an explanation of a formula: | New Users to Excel | |||
| FORMULA EXPLANATION | New Users to Excel | |||
| Formula Explanation Please | Excel Discussion (Misc queries) | |||
| Formula Explanation | Excel Programming | |||
Linear Mode
