fill series of multiple rows and columns

jas · Jul 30, 2008

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 · Jul 30, 2008

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

Regards,
Pedro J.

jas · Jul 30, 2008

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

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

Infinitogool · Jul 30, 2008

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

Pedro J.

jas · Jul 30, 2008

done, thanks,

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

Pedro J.