|
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 |
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 |
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 |
| All times are GMT +1. The time now is 07:55 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com