| Home |
| Search |
| Today's Posts |
|
#1
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
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
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
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
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
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Join non-contiguous ranges into one range via named range? | Excel Discussion (Misc queries) | |||
| I have doubt regarding the find a result with two criteria's!! | Excel Worksheet Functions | |||
| Formula for totaling occurrences in a specified range | Excel Worksheet Functions | |||
| x y scatter chart series ranges reset to x(range) = y(range) | Charts and Charting in Excel | |||
| COUNTIF with two criteria's | Excel Worksheet Functions | |||
Linear Mode
