SUM Values in every nth column

[SierraKilo78]

help please again!!!

I have a worksheet that has data spread over columns. i need to now sum the values in a particular column and then sum of every 33rd column.

It is a format that has standard data from column A-AF, and then the format repeats from AH-BM. so i need the sum of values column R and then AQ and thereon, every 33rd column.

i tried the following formula and searches but obviously nothing worked so writing to the experts out there.

im attaching a sample workbook with the data in sheet 1 and the expected result in sheet 2.

would be grateful of any help!!

[Jonmo1]

Try

=SUM(OFFSET(Sheet1!$R:$R,0,(ROWS(A$1:A1)-1)*33))

[SierraKilo78]

oh! perfect!

didn't know it was that simple!

thanks a bunch

[Jonmo1]

You're welcome.