fill series of multiple rows and columns
 

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

fill series of multiple rows and columns
 

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

fill series of multiple rows and columns
 

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


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

"Infinitogool" wrote:

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

fill series of multiple rows and columns
 

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

Pedro J.

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


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

"Infinitogool" wrote:

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

fill series of multiple rows and columns
 

done, thanks,

"Infinitogool" wrote:

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

Pedro J.

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


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

"Infinitogool" wrote:

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