Home |
Search |
Today's Posts |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula to stop adding at a positive number
confused, i may have read it on another way
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. then you may try either of the two.. =sum(A1:E1)+sumif(F1:G1,"<0") if either F or G is a negative to qualify in summing with A:E or =sum(A1:E1)+if(and(F1<0,G1<0),F1+G1,0) if needs both F and G as negative in order to qualify for summing with A:E... regards -- ***** birds of the same feather flock together.. "nkhelp" wrote: 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 |