sum positive and negative 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.
 
S

somethinglikeant

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
 
S

somethinglikeant

would help if i put the formula in

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

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 positive and negative values 2
sum negative and positive values separately 7
League age chart 4
Problems with X Axis for a Line Chart 3
Need to replace one dynamic variable with another dynamic variable 8
Excel date intervals look up 1
Reallocate array cells value from positive to negative 0
Find value, copy, compute, and more 5

Top