sum every four rows

[yankee428]

column of 100 rows

i need to sum every fourth line. for example

1
2
3
4 sum = 10
5
6
7
8 sum = 26

 

[Pekkavee]

Put in B4

=SUM(A1:A4)

Then select range B1:B4 and drag down as far as needed.

Pekka

Työkirja1
	A	B	C	D
1	1
2	2
3	3
4	4	10
5	5
6	6
7	7
8	8	26
9	9
10	10
11	11
12	12	42
13	13
14	14
15	15
16	16	58
Taul1

 

[vane0326]

The procedure colbymack describes is the best thing to execute.

Is what its name colbymack ? If so how does it works ?

 

[just_jon]

Insert a column. In the fourth row of the new column, put a formula that sums the cell to the left of it and the three cells above that one.
In the new column, highlight the cell with the formula and the three above it. Select Edit Copy. Starting with the cell just below it, highlight all the way down to the last row. Selecte Edit Paste.

hth,
Colbymack

No, see the above.

Aladin: Sorry, I was bored!

 

[Pekkavee]

Is what its name colbymack ? If so how does it works ?

Have a look into my example.

Simple is beautiful

Pekka