Calculating return for multiple separate time periods
Enter this formula in E1 and copy down as needed:
=IF(D1="","",SUM(B1:OFFSET(B1,,,-1*D1)))
Format as %
--
Biff
Microsoft Excel MVP
"trey1982" wrote in message
...
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
|