Multiple Conditions
 

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....

Multiple Conditions
 

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" wrote in message
...
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....

Multiple Conditions
 

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" wrote in message
...
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....

Multiple Conditions
 

Post some data examples.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Looney" wrote in message
...
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" wrote in message
...
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....

Multiple Conditions
 

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" wrote in message
...
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" wrote in message
...
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....