| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMIF with area that is not a range
I am trying to sumif cells that are not consecutive.
Here is what I have so far: =IF((I8,Q8,Y8,AG8,AO8,AW8,BE8,BM8,BU8,CC8,CK8,CS8, DA8,DI8),"paid",(I8+Q8+Y8+AG8+AO8+AW8+BE8+BM8+BU8+ CC8+CK8+CS8+DA8+DI8)) These cells need a sum: I8,Q8,Y8,AG8,AO8,AW8,BE8,BM8,BU8,CC8,CK8,CS8,DA8,D I8 if "paid" |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I enter formula sum(range+range)*0.15 sumif(range=3) | Excel Discussion (Misc queries) | |||
| Formula for Range area within VLookup? | Excel Worksheet Functions | |||
| Print Area as dynamic range? | Excel Worksheet Functions | |||
| Print area/range | Excel Discussion (Misc queries) | |||
| SUMIF - Range name to used for the "sum_range" portion of a SUMIF function | Excel Worksheet Functions | |||
Threaded Mode
