Countif OR Sumproduct- I NEED HELP

  • Thread starter Thread starter dareal
  • Start date Start date
D

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.
 
Try this:

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

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

Hope this helps.

Pete
 
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)
 
Back
Top