sum negative and positive values separately

B

bora

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

sum negative and positive values separately 7
sum positive and negative values separately 3
sum positive and negative values 2
League age chart 4
Need to replace one dynamic variable with another dynamic variable 9
Excel date intervals look up 1
Problems with X Axis for a Line Chart 3
conditional SUM by dates and values 6

Top