Multiple Conditions

[Guest]

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)

 

[Guest]

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]

Post some data examples.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

 

[Guest]

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.