| 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 |
| 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 | |||
Threaded Mode
