Still need help on annualized rolling sum

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Hunter - 16 Aug 2006 18:42 GMT

I am trying to calculate an annualized rolling sum for data as follows:

ColumA Column B
10/01/97 5
10/12/97 6
12/5/97 3
1/5/98 2
1/15/98 6
6/15/98 9
8/12/98 7
etc

I want to be able to calculate on each date the sum of column B for the past
year.

Reply to this Message

David Billigmeier - 16 Aug 2006 18:51 GMT

Assume your data goes from row 1 to 30, place this formula in C1 and drag down.

=SUMPRODUCT(--($A$1:$A$30<A1),--($A$1:$A$30>=A1-365),$B$1:$B$30)

Signature

Regards,
Dave

> I am trying to calculate an annualized rolling sum for data as follows:
>
[quoted text clipped - 10 lines]
> I want to be able to calculate on each date the sum of column B for the past
> year.

Reply to this Message