If you went from Column A to Column IV, *only* the "first column series"
would contain 52 values.
All the rest would have 51.

That being the case, this formula will total column A to IV on Row10,
starting in A:

=SUMPRODUCT((MOD(COLUMN(10:10)+4,5)=0)*(10:10))

Starting in B:
=SUMPRODUCT((MOD(COLUMN(10:10)+3,5)=0)*(10:10))

Starting in C:
=SUMPRODUCT((MOD(COLUMN(10:10)+2,5)=0)*(10:10))

Starting in D:
=SUMPRODUCT((MOD(COLUMN(10:10)+1,5)=0)*(10:10))

Starting in E:
=SUMPRODUCT((MOD(COLUMN(10:10),5)=0)*(10:10))


--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===


"KLock" wrote in message
...
I have to add every sixth value in a column summed over 52 value. Is there
an equation to do this so I don't have to input each cell.

Example

Column 1 2 3 4 5 1 2 3 4 5

So the equation I need is Column (1+1), Column (2+2), so on