I, for one, don't understand what you want. A better example.

--
Don Guillett
SalesAid Software

"bora" wrote in message
ps.com...
Hi, I am looking for a vba routine
I have a time series like this:

1995, -.05
1996, -2.1
1997, 3.6
1998, 4.3
1999, 0.7
2000, -0.08
2001, -0.1

and I would like to sum just the positive and negative value separately
in this way

1995, -2.15
1996, 8.6
1999, -0.18
i.e the sum of negative or positive values should be associated to the
last date of the previous growth or drop. I don't know in advance the
length of period of drop and growth

Thanks in advance.