Hi jas
Try
=SUM(OFFSET($A$1,,5*(COLUMN(A1)-1),10,5))

Regards,
Pedro J.

I am wanting to fill a series with 5 columns to a single cell on another sheet.
Want it like this =sum(A1:E10) next cell. =sum(F1:J10).
When I drag fill handle it comes up =sum(A1:E10) next cell =sum(B1:F10) etc
Can tou help