moving sum
 

Hi,
I have a list of monthly payments, and I want to create a column that sums
those at the end of each year, six months or a quarter .
EX:
1 0
1 0
2 4
4 0
1 0
1 6
....
What formula should I use in the second column to have a sum at every
12th,6th or 3rd row?
Thanks. Neda

Assume your data begins in A1. In B3 use:

=SUM(A1:A3)

Select B1:B3, grab the fill handle, and fill down. This
will sum every 3 rows. For every six rows, in B6 use:

=SUM(A1:A6)

Select B1:B6 and fill down. Same process for every 12
rows.

HTH
Jason
Atlanta, GA

-----Original Message-----
Hi,
I have a list of monthly payments, and I want to create
a column that sums
those at the end of each year, six months or a quarter .
EX:
1 0
1 0
2 4
4 0
1 0
1 6
....
What formula should I use in the second column to have a
sum at every
12th,6th or 3rd row?
Thanks. Neda
.

Thanks Jason, but the idea is to have one formula to paste and copy from
begunning to end, since mu columns are couple of thousand rows long., and if
I go and repaste it every six or so rows it takes forever.
Neda

"Jason Morin" wrote:

Assume your data begins in A1. In B3 use:

=SUM(A1:A3)

Select B1:B3, grab the fill handle, and fill down. This
will sum every 3 rows. For every six rows, in B6 use:

=SUM(A1:A6)

Select B1:B6 and fill down. Same process for every 12
rows.

HTH
Jason
Atlanta, GA

-----Original Message-----
Hi,
I have a list of monthly payments, and I want to create
a column that sums
those at the end of each year, six months or a quarter .
EX:
1 0
1 0
2 4
4 0
1 0
1 6
....
What formula should I use in the second column to have a
sum at every
12th,6th or 3rd row?
Thanks. Neda
.

Got what you meant. It works fine. Thanks.

"Jason Morin" wrote:

Assume your data begins in A1. In B3 use:

=SUM(A1:A3)

Select B1:B3, grab the fill handle, and fill down. This
will sum every 3 rows. For every six rows, in B6 use:

=SUM(A1:A6)

Select B1:B6 and fill down. Same process for every 12
rows.

HTH
Jason
Atlanta, GA

-----Original Message-----
Hi,
I have a list of monthly payments, and I want to create
a column that sums
those at the end of each year, six months or a quarter .
EX:
1 0
1 0
2 4
4 0
1 0
1 6
....
What formula should I use in the second column to have a
sum at every
12th,6th or 3rd row?
Thanks. Neda
.