how to create the formula for that attached explanation

[Guest]

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

 

[Bob Phillips]

=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)

 

[Guest]

Many Thanks Bob and your prompt reply

=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)