=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