Prev: Text from number
Next: Duplicates
From: dareal on 4 Mar 2010 07:28
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.
From: Pete_UK on 4 Mar 2010 07:35
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 <dar...(a)discussions.microsoft.com> 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.

From: JLatham on 4 Mar 2010 07:42
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.
From: JLatham on 4 Mar 2010 07:58
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.
 | 
Pages: 1
Prev: Text from number
Next: Duplicates