| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula to stop adding at a positive number
I need help with the formula to stop adding when the cell number becomes a
positive number. I am looking at different senarios for a breakeven point. I need one cell to add only numbers that are negative. EXAMPLE A B C D E F G SUM -10 -5 -4 -1 2 4 I need A1 to add only through E1, but the sum addition needs to include cells F-G because they may change to a negative number when I change another calculation. Make Sense? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to convert a month to a quarter ...... | New Users to Excel | |||
| Find value in array | Excel Worksheet Functions | |||
| Vlookup to Return a Range of Data | Excel Discussion (Misc queries) | |||
| Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
| What is the formula for adding a number of days to an existing dat | Excel Worksheet Functions | |||
Threaded Mode
