| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
sum positive and negative values separately
Hi,
I have a time series like this: 1995, -.05 1996, -2.1 1997, 3.6 1998, 4.3 1999, -0.7 2000, -0.08 and I would like to sum just the positive and negative value separately in this way 1995, -2.15 1997, 7.9 1999, -0.78 And I don't know if it is possible, thanks in advance. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| summing only positive or negative values | Excel Worksheet Functions | |||
| Sorting Negative with Positive Values | Excel Discussion (Misc queries) | |||
| Changing positive values to negative | New Users to Excel | |||
| Formula to make Negative Values Positive & Positive Values Negative? | Excel Discussion (Misc queries) | |||
| ... Count, <<< Positive Values minus Negative Values >>> ... | Excel Worksheet Functions | |||
Threaded Mode
