L
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...
I have tried using the following function but all I get is zeros.
=SUMPRODUCT(--('SHEET B'!b2:b100="Other Funds"),--('SHEET B a2:a100='SHEET
A'!A1),'SHEET B'!C2:C100)
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...
I have tried using the following function but all I get is zeros.
=SUMPRODUCT(--('SHEET B'!b2:b100="Other Funds"),--('SHEET B a2:a100='SHEET
A'!A1),'SHEET B'!C2:C100)