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

Do you mean

=SUMPRODUCT(--('SHEET B'!b2:b100=quot;Other Fundsquot;),--('SHEET B'!a2:a100='SHEET
A'!A1),'SHEET B'!C2:C100)

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

quot;Looneyquot; gt; wrote in message
...
gt; I'm trying to add the values in SHEET B column C2:C100 but only if they
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
column
gt; a2:a100 has to equal SHEET A column a1, a2, a3....
Thanks for the response Bob. Yes, that's exactly what I mean. I have tried
that formula but all I get is zeros.

quot;Bob Phillipsquot; wrote:

gt; Do you mean
gt;
gt; =SUMPRODUCT(--('SHEET B'!b2:b100=quot;Other Fundsquot;),--('SHEET B'!a2:a100='SHEET
gt; A'!A1),'SHEET B'!C2:C100)
gt;
gt; --
gt;
gt; HTH
gt;
gt; Bob Phillips
gt;
gt; (remove nothere from the email address if mailing direct)
gt;
gt; quot;Looneyquot; gt; wrote in message
gt; ...
gt; gt; I'm trying to add the values in SHEET B column C2:C100 but only if they
gt; meet
gt; gt; two criterias. I want my answer in SHEET A colum h. In order to get a
gt; gt; result, SHEET B column b2:b100 has to equal quot;Other Fundsquot; and SHEET b
gt; column
gt; gt; a2:a100 has to equal SHEET A column a1, a2, a3....
gt;
gt;
gt;

Post some data examples.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

quot;Looneyquot; gt; wrote in message
...
gt; Thanks for the response Bob. Yes, that's exactly what I mean. I have
tried
gt; that formula but all I get is zeros.
gt;
gt; quot;Bob Phillipsquot; wrote:
gt;
gt; gt; Do you mean
gt; gt;
gt; gt; =SUMPRODUCT(--('SHEET B'!b2:b100=quot;Other Fundsquot;),--('SHEET
B'!a2:a100='SHEET
gt; gt; A'!A1),'SHEET B'!C2:C100)
gt; gt;
gt; gt; --
gt; gt;
gt; gt; HTH
gt; gt;
gt; gt; Bob Phillips
gt; gt;
gt; gt; (remove nothere from the email address if mailing direct)
gt; gt;
gt; gt; quot;Looneyquot; gt; wrote in message
gt; gt; ...
gt; gt; gt; I'm trying to add the values in SHEET B column C2:C100 but only if
they
gt; gt; meet
gt; gt; gt; two criterias. I want my answer in SHEET A colum h. In order to get
a
gt; gt; gt; result, SHEET B column b2:b100 has to equal quot;Other Fundsquot; and SHEET b
gt; gt; column
gt; gt; gt; a2:a100 has to equal SHEET A column a1, a2, a3....
gt; gt;
gt; gt;
gt; gt;
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.

quot;Bob Phillipsquot; wrote:

gt; Post some data examples.
gt;
gt; --
gt;
gt; HTH
gt;
gt; Bob Phillips
gt;
gt; (remove nothere from the email address if mailing direct)
gt;
gt; quot;Looneyquot; gt; wrote in message
gt; ...
gt; gt; Thanks for the response Bob. Yes, that's exactly what I mean. I have
gt; tried
gt; gt; that formula but all I get is zeros.
gt; gt;
gt; gt; quot;Bob Phillipsquot; wrote:
gt; gt;
gt; gt; gt; Do you mean
gt; gt; gt;
gt; gt; gt; =SUMPRODUCT(--('SHEET B'!b2:b100=quot;Other Fundsquot;),--('SHEET
gt; B'!a2:a100='SHEET
gt; gt; gt; A'!A1),'SHEET B'!C2:C100)
gt; gt; gt;
gt; gt; gt; --
gt; gt; gt;
gt; gt; gt; HTH
gt; gt; gt;
gt; gt; gt; Bob Phillips
gt; gt; gt;
gt; gt; gt; (remove nothere from the email address if mailing direct)
gt; gt; gt;
gt; gt; gt; quot;Looneyquot; gt; wrote in message
gt; gt; gt; ...
gt; gt; gt; gt; I'm trying to add the values in SHEET B column C2:C100 but only if
gt; they
gt; gt; gt; meet
gt; gt; gt; gt; two criterias. I want my answer in SHEET A colum h. In order to get
gt; a
gt; gt; gt; gt; result, SHEET B column b2:b100 has to equal quot;Other Fundsquot; and SHEET b
gt; gt; gt; column
gt; gt; gt; gt; a2:a100 has to equal SHEET A column a1, a2, a3....
gt; gt; gt;
gt; gt; gt;
gt; gt; gt;
gt;
gt;
gt;