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

A

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
 
J

Jacob Skaria

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

If this post helps click Yes
 
A

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

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
 
A

ADC76

That did it! Works great!
Thanks Jacob.

ADC76

Jacob Skaria said:
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" كتب:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top