| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Finding and Adding
Hi,
Have a problem hopefully I can get some help with. I need a formula to find the last positive number in a row and then add that and all the numbers that come after it. Example: -10 100 -10 -20 60 -10 -20 I need the formula to locate the 60 and then add 60+(-10)+(-20) Thanks in advance! Rich |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Finding * | Excel Discussion (Misc queries) | |||
| Finding The MAX Value | Excel Worksheet Functions | |||
| Finding a value by adding certain sums in a range? | Excel Discussion (Misc queries) | |||
| Finding a match and adding to the statement | Excel Discussion (Misc queries) | |||
| finding the last value | Excel Discussion (Misc queries) | |||
Threaded Mode
