| 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 |
| 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 | |||
Threaded Mode
