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