Sum every 4th column

[abee4life]

Hi,

I have been creating a work time sheet for myself (its pay day today and I think I've been underpaid).

I need a formula that can calculate a sum from every 4th column.

Starting from B3, I would like it calculate B3, F3, J3, N3 etc and add them up.

Please help. My result would go in A1.

 

[Michael M]

Maybe this from Andrew Poulsom

http://www.mrexcel.com/forum/excel-questions/454159-sum-every-nth-column-row.html

Excel 2007
	A	B	C	D	E	F	G	H	I	J	K	L	M	N
1	22
2
3		5	6	7	8	4	5	6	7	4	5	6	7	9
Sheet1

Cell Formulas
Range	Formula
A1	=SUMPRODUCT(--(MOD((COLUMN(B3:N3)-COLUMN(B3)),4)=0),B3:N3)

 

[abee4life]

thank you