Multiple Conditions

[Looney]

I'm trying to add the values in SHEET B column C2:C100 but only if they meet
two criterias. I want my answer in SHEET A colum h. In order to get a
result, SHEET B column b2:b100 has to equal "Other Funds" and SHEET b column
a2:a100 has to equal SHEET A column a1, a2, a3....

[Bob Phillips]

Do you mean

=SUMPRODUCT(--('SHEET B'!b2:b100="Other Funds"),--('SHEET B'!a2:a100='SHEET
A'!A1),'SHEET B'!C2:C100)

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Looney" <[email protected]> wrote in message
news:[email protected]...
> I'm trying to add the values in SHEET B column C2:C100 but only if they
meet
> two criterias. I want my answer in SHEET A colum h. In order to get a
> result, SHEET B column b2:b100 has to equal "Other Funds" and SHEET b
column
> a2:a100 has to equal SHEET A column a1, a2, a3....

[Looney]

Thanks for the response Bob. Yes, that's exactly what I mean. I have tried
that formula but all I get is zeros.

"Bob Phillips" wrote:

> Do you mean
>
> =SUMPRODUCT(--('SHEET B'!b2:b100="Other Funds"),--('SHEET B'!a2:a100='SHEET
> A'!A1),'SHEET B'!C2:C100)
>
> --
>
> HTH
>
> Bob Phillips
>
> (remove nothere from the email address if mailing direct)
>
> "Looney" <[email protected]> wrote in message
> news:[email protected]...
> > I'm trying to add the values in SHEET B column C2:C100 but only if they
> meet
> > two criterias. I want my answer in SHEET A colum h. In order to get a
> > result, SHEET B column b2:b100 has to equal "Other Funds" and SHEET b
> column
> > a2:a100 has to equal SHEET A column a1, a2, a3....
>
>
>

[Bob Phillips]

Post some data examples.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Looney" <[email protected]> wrote in message
news:[email protected]...
> Thanks for the response Bob. Yes, that's exactly what I mean. I have
tried
> that formula but all I get is zeros.
>
> "Bob Phillips" wrote:
>
> > Do you mean
> >
> > =SUMPRODUCT(--('SHEET B'!b2:b100="Other Funds"),--('SHEET
B'!a2:a100='SHEET
> > A'!A1),'SHEET B'!C2:C100)
> >
> > --
> >
> > HTH
> >
> > Bob Phillips
> >
> > (remove nothere from the email address if mailing direct)
> >
> > "Looney" <[email protected]> wrote in message
> > news:[email protected]...
> > > I'm trying to add the values in SHEET B column C2:C100 but only if
they
> > meet
> > > two criterias. I want my answer in SHEET A colum h. In order to get
a
> > > result, SHEET B column b2:b100 has to equal "Other Funds" and SHEET b
> > column
> > > a2:a100 has to equal SHEET A column a1, a2, a3....
> >
> >
> >

[Looney]

The formula works great Bob. I found out that excel was reading one of the
column as text and the other as number.

Once again, thanks for all your help Bob.

"Bob Phillips" wrote:

> Post some data examples.
>
> --
>
> HTH
>
> Bob Phillips
>
> (remove nothere from the email address if mailing direct)
>
> "Looney" <[email protected]> wrote in message
> news:[email protected]...
> > Thanks for the response Bob. Yes, that's exactly what I mean. I have
> tried
> > that formula but all I get is zeros.
> >
> > "Bob Phillips" wrote:
> >
> > > Do you mean
> > >
> > > =SUMPRODUCT(--('SHEET B'!b2:b100="Other Funds"),--('SHEET
> B'!a2:a100='SHEET
> > > A'!A1),'SHEET B'!C2:C100)
> > >
> > > --
> > >
> > > HTH
> > >
> > > Bob Phillips
> > >
> > > (remove nothere from the email address if mailing direct)
> > >
> > > "Looney" <[email protected]> wrote in message
> > > news:[email protected]...
> > > > I'm trying to add the values in SHEET B column C2:C100 but only if
> they
> > > meet
> > > > two criterias. I want my answer in SHEET A colum h. In order to get
> a
> > > > result, SHEET B column b2:b100 has to equal "Other Funds" and SHEET b
> > > column
> > > > a2:a100 has to equal SHEET A column a1, a2, a3....
> > >
> > >
> > >
>
>
>