| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to sum this easily...?
hello again gangs,
below is my sample data A B C 10 0 10 1.00 14 2.00 =(10+14+12+10)=46 12 1.50 10 0.50 16 0 10 0 10 -0.90 8 -1.90 12 -2.00 =(10+8+12+10)=40 10 -1.80 10 0 10 1.00 --------------------------- i need to sum many SEPARATE ranges in column A, if column B <0, and place the summed range total on column C where the max or min value (other than 0) on column B is adjacent. i do not have blank cells .... really tried this but maybe i can't just do it without this forum... regards driller -- ***** birds of the same feather flock together.. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I easily link a block of cells in one spreadsheet to anothe | Excel Discussion (Misc queries) | |||
| Lock easily breaks. | Excel Discussion (Misc queries) | |||
| how to copy the same cell across different work books into another workbook easily? | Excel Discussion (Misc queries) | |||
| How to easily collapse columns? | Excel Discussion (Misc queries) | |||
| How do I easily draw in Excel the Upper and Lower limits of a con. | Charts and Charting in Excel | |||
Threaded Mode
