| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is it possible to chart series data from multiple rows in a table? | Charts and Charting in Excel | |||
| Fill Series Dates: not letting me change the series from year to m | Excel Discussion (Misc queries) | |||
| Charts switch from 'Series in Rows' to 'Series in Columns' | Charts and Charting in Excel | |||
| Fill down Multiple Rows? | Excel Discussion (Misc queries) | |||
| multiple rows and column, chart into 1 series? | Charts and Charting in Excel | |||
Hybrid Mode
