| Home | Forums | Reviews | Articles | Register |
 |
| Thread Tools | Rate Thread |
|
Guest
Posts: n/a
|
|
|
|
||
|
|
| |
|
Guest
Posts: n/a
|
=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" <(E-Mail Removed)> wrote in message news  2EC10B0-7D0B-48B4-872C-(E-Mail Removed)...> 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 > |
|
|
|
|
|||
|
Guest
Posts: n/a
|
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" <(E-Mail Removed)> wrote in message > news 2EC10B0-7D0B-48B4-872C-(E-Mail Removed)...> > 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 > > > > > |
|
|
|
|
|||
|
|
| |
|
| Thread Tools | |
| Rate This Thread | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| formula explanation | Hoops | Microsoft Excel Misc | 3 | 20th Jan 2010 03:59 PM |
| Formula Explanation | rition@hotmail.com | Microsoft Excel Discussion | 5 | 14th Mar 2006 01:15 AM |
| Explanation of attached formula requested. | Bill | Microsoft Excel Worksheet Functions | 3 | 27th Aug 2004 10:31 AM |
| explanation for formula Please. | Steved | Microsoft Excel Worksheet Functions | 5 | 18th Aug 2004 03:11 AM |
| Explanation of formula | marksuza | Microsoft Excel Worksheet Functions | 1 | 4th Dec 2003 01:55 PM |
