|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
May 15th, 2009, 06:50 AM
posted to microsoft.public.excel.misc
|
|||
|
|||
SUMIF with 2 ranges and 2 criteria's, totaling the same sum range.
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 
|
|
#2
May 15th, 2009, 07:02 AM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
SUMIF with 2 ranges and 2 criteria's, totaling the same sum range.
=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
|
|
#3
May 15th, 2009, 07:20 AM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
SUMIF with 2 ranges and 2 criteria's, totaling the same sum ra
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
|
|
#4
May 15th, 2009, 08:00 AM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
SUMIF with 2 ranges and 2 criteria's, totaling the same sum ra
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
|
|
#5
May 15th, 2009, 08:19 AM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
SUMIF with 2 ranges and 2 criteria's, totaling the same sum ra
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
|
|
#6
May 15th, 2009, 11:47 AM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
SUMIF with 2 ranges and 2 criteria's, totaling the same sum ra
that from (sumifs) in 2007 office
-- السلام عليكم بتمنى من المستفيد من معلوماتي ان يساعد شخصين بالمقابل واخباره عن طارق وعهد لكم أن لا ابخل باي جواب مهما كان والله يقدرني على نشر المعرفة وشكرا طارق شكير "ADC76" كتب: 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
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
