fill series of multiple rows and columns

[jas]

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

 

[Infinitogool]

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

Regards,
Pedro J.

 

[jas]

below is my actual equation, would you be kind enough to show using this?


=SUM('labour totals'!E3:I11)

 

[Infinitogool]

Hi jas
Try
=SUM(OFFSET('labour totals'!$E$3,,5*(COLUMN(A1)-1),9,5))

Pedro J.

 

[jas]

done, thanks,

Hi jas
Try
=SUM(OFFSET('labour totals'!$E$3,,5*(COLUMN(A1)-1),9,5))

Pedro J.