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.

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

sum positive and negative values separately
 

would help if i put the formula in

=IF(ODD(ROW())=ROW(),SUM(B1:B2),"")

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),"")