Countif OR Sumproduct- I NEED HELP
 

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.

Countif OR Sumproduct- I NEED HELP
 

Try this:

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

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

Hope this helps.

Pete

On Mar 4, 12:28*pm, dareal wrote:
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.

Countif OR Sumproduct- I NEED HELP
 

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)


"dareal" wrote:

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.

Countif OR Sumproduct- I NEED HELP
 

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

"JLatham" wrote:

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)


"dareal" wrote:

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.