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