It might be easier if you have a start date (eg in E1) and an end date
(in F1) to define a continuous range, and then a formula in G1 to
provide the returns within that period. Where you have discontinuous
ranges, you can put these in the rows below (eg Jun-06 in both E2 and
F2, and Aug-06 in E3 and Feb-07 in F3), and copy the formula from G1
into G2:Gn as appropriate, and then add these up.

Hope this helps.

Pete

On Dec 11, 3:39 pm, trey1982
wrote:
How can I go about creating a formula that calculates the returns for strings
of positive returns? Sample data is below i.e. return for Jan-06 to Mar-06,
Jun-06, and Aug-06 to Feb-07. (everytime column D0)

thanks...trey

Motnh



Jan-06 1.37% 1
Feb-06 0.99% 2
Mar-06 0.12% 3 3
Apr-06 -0.45% 0
May-06 -0.18% 0
Jun-06 0.30% 1 1
Jul-06 -0.21% 0
Aug-06 0.38% 1
Sep-06 0.74% 2
Oct-06 0.37% 3
Nov-06 1.50% 4
Dec-06 1.40% 5
Jan-07 0.39% 6
Feb-07 1.44% 7 7
Mar-07 -0.09% 0
Apr-07 -0.74% 0 - Hide quoted text -

- Show quoted text -