Countif OR Sumproduct- I NEED HELP

[dareal]

HI,
I need a formula to create
I need to count number of items in #SHEET1 $B:$B if VALUE in #Sheet1
$A:$A matches #SHEET2 $A3.

Please Help Me.

 

[Pete_UK]

Try this:

=COUNTIF(Sheet1!$A:$A,Sheet2!$A3)

Not sure what criteria, if any, you have for column B.

Hope this helps.

Pete

 

[JLatham]

If you just need a count then a very simple
=COUNTIF(Sheet1!$A:$A=Sheet2!$A$3)
will do it.
But if you need a total of quantities in B on Sheet1 based on the match of
A3 to A:A on sheet 1, then
=SUMIF(Sheet1!$A:$A,"=" & Sheet2!$A$3, Sheet1!$B:$B)

 

[JLatham]

Oops, the COUNTIF() formula should have been
=COUNTIF(Sheet1!$A:$A, Sheet2!$A$3)