software

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 quot;Other Fundsquot; 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=quot;Other Fundsquot;),--('SHEET B a2:a100='SHEET
A'!A1),'SHEET B'!C2:C100)
Hi!

--('SHEET B a2:a100='SHEET

Other than the above typo, which would cause Excel to balk and throw up an
error msg, there's nothing wrong with your formula so you should check your
data.

Things to check for:

Leading and/or trailing spaces that you can't see.
TEXT numbers instead of NUMERIC numbers in 'SHEET B'!C2:C100

Biff

quot;Looneyquot; gt; wrote in message
...
gt; I'm trying to add the values in SHEET B column C2:C100 but only if they
gt; meet
gt; two criterias. I want my answer in SHEET A colum h. In order to get a
gt; result, SHEET B column b2:b100 has to equal quot;Other Fundsquot; and SHEET b
gt; column
gt; a2:a100 has to equal SHEET A column a1, a2, a3...
gt;
gt; I have tried using the following function but all I get is zeros.
gt; =SUMPRODUCT(--('SHEET B'!b2:b100=quot;Other Fundsquot;),--('SHEET B a2:a100='SHEET
gt; A'!A1),'SHEET B'!C2:C100)
gt;
gt;