| 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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
sum positive and negative values separately
All is possible.
Free your mind and your ass will follow Assuming your original list is in column A and B paste the following formula into C1 and paste down as far as you need. http://www.excel-ant.co.uk |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
sum positive and negative values separately
would help if i put the formula in
=IF(ODD(ROW())=ROW(),SUM(B1:B2),"") |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
sum positive and negative values separately
It works well, thank you so much
regards Guido somethinglikeant ha scritto: would help if i put the formula in =IF(ODD(ROW())=ROW(),SUM(B1:B2),"") |
| Reply |
| 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 | |||
Linear Mode
