| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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 . |
|
#3
|
|||
|
|||
|
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 . |
|
#4
|
|||
|
|||
|
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 . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Arrow keys move screen instead of moving from cell to cell. | Setting up and Configuration of Excel | |||
| Moving page up and down with arrow keys instead of individual cel. | Excel Discussion (Misc queries) | |||
| Moving text in a cell | Excel Worksheet Functions | |||
| Moving numbers from one sheet to another by date | Excel Worksheet Functions | |||
| Moving Down a Cell in Macro | Excel Discussion (Misc queries) | |||
Linear Mode
