SUMIF with 2 ranges and 2 criteria's, totaling the same sum range.

[ADC76]

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

 

[Jacob Skaria]

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

If this post helps click Yes

 

[ADC76]

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]

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

 

[ADC76]

That did it! Works great!
Thanks Jacob.

ADC76

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

 

[طارق شكير]

that from (sumifs) in 2007 office
--
السلام عليكم بتمنى من المستÙيد من معلوماتي ان يساعد شخصين بالمقابل واخباره
عن طارق وعهد لكم أن لا ابخل باي جواب مهما كان والله يقدرني على نشر المعرÙØ©
وشكرا طارق شكير


"ADC76" كتب: