Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Summing a range of cells based on criteria in another range
A8 = 300 B8 = 600 C8 = sum of B8-A8 or 300 D8 = 100% E8 = + A9 = 200 B9 = 150 C9 = sum of B9-A9 or = -50 D9 = -25.0% E8 = - A10 = 100 B10 = 100 C10 = sum of B10-A810 or = 0 D9 = 0.0% E8 = 0 The formula I need will scan the E column for all cells that contain a "+", then add those cells in the C column that correspond, delivering one total. Same for the "-" and the "0" in E column. Appreciate any help. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Summing a range of cells based on criteria in another range
Try these:
=SUMIF(E:E,"+",C:C) for the + sign, and: =SUMIF(E:E,"-",C:C) for the negatives, and: =SUMIF(E:E,0,C:C) for the zero values. Hope this helps. Pete On Nov 4, 11:52*pm, Jack wrote: A8 = 300 * * B8 = 600 * C8 = sum of B8-A8 or 300 * * * * *D8 = 100% * * * E8 = + A9 = 200 * * B9 = 150 * C9 = *sum of B9-A9 or = *-50 * * *D9 = -25.0% * *E8 = - A10 = 100 * B10 = 100 *C10 = *sum of B10-A810 or = 0 *D9 = 0.0% * * * *E8 = 0 The formula I need will scan the E column for all cells that contain a "+", then add those cells in the C column that correspond, delivering one total. * Same for the "-" and the "0" in E column. Appreciate any help. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Summing a range of cells based on criteria in another range
Try
=SUMIF(E:E,"+",C:C) =SUMIF(E:E,"-",C:C) You can do that without using colE as =SUMIF(C:C,"0") =SUMIF(C:C,"<0") If this post helps click Yes --------------- Jacob Skaria "Jack" wrote: A8 = 300 B8 = 600 C8 = sum of B8-A8 or 300 D8 = 100% E8 = + A9 = 200 B9 = 150 C9 = sum of B9-A9 or = -50 D9 = -25.0% E8 = - A10 = 100 B10 = 100 C10 = sum of B10-A810 or = 0 D9 = 0.0% E8 = 0 The formula I need will scan the E column for all cells that contain a "+", then add those cells in the C column that correspond, delivering one total. Same for the "-" and the "0" in E column. Appreciate any help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Summing a range of cells with criteria | Excel Worksheet Functions | |||
Summing based on a range of criteria | Excel Discussion (Misc queries) | |||
Summing a range based on value criteria | Excel Discussion (Misc queries) | |||
Add text to begining of cells within a range based on specified criteria | Excel Discussion (Misc queries) | |||
color a range of cells based on a criteria | Excel Discussion (Misc queries) |