B
Brenden23
I have two columns: Column A with dates, and Column B with daily returns. I
want to know if there's an efficient way to calculate a series of monthly
returns for each calendar month without having to manually select the
appropriate range for each month in the formula.
Essentially, is there a way I can say "Sum the totals in january 2009" and
then pull the formula down, and it will roll over to corresponding months in
each cell. Or some workaround that's as effective.
Any ideas?
want to know if there's an efficient way to calculate a series of monthly
returns for each calendar month without having to manually select the
appropriate range for each month in the formula.
Essentially, is there a way I can say "Sum the totals in january 2009" and
then pull the formula down, and it will roll over to corresponding months in
each cell. Or some workaround that's as effective.
Any ideas?