That did it! Works great!
Thanks Jacob.

ADC76

"Jacob Skaria" wrote:

Try the below

=SUMPRODUCT(--((A1:A10="s")+(B1:B10="rd")0),--C1:C10)

The earlier formula works if both "s" and "rd" are present in the same row..
Sorry i misunderstood your initial query.

If this post helps click Yes
---------------
Jacob Skaria


"ADC76" wrote:

Still not working. I put an "s" in the A column with a dollar amount in the
C column and got no result. I put an "rd" in the B column with a dollar
amount in the C column and got no result as well.
I would like C1:C10 to total result whether I put an "s" in the A column or
"rd" in the B column. I have other textual codes like these that I do not
want to total when they are entered so I figured not to mention them.


"Jacob Skaria" wrote:

=SUMPRODUCT(--(A1:A10="S"),--(B1:B10="RD"),--(C1:C10))

If this post helps click Yes
---------------
Jacob Skaria


"ADC76" wrote:

Hello,
I'm trying to modify an existing formula which only adds the sum range if
another range has an "s" in it. Here's the formula: =SUMIF(A1:A10,"S",C1:C10)

Now I would like to add another range and condition to the formula. I was
thinking:
(B1:B10,"RD"). I don't know how to incorporate that into the existing
formula though. C1:C10 still remaining the sum_range, as it is.

Thanks for your help,
ADC76