| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I fill a sum formula for for quarters into adjacent years
I want to take the sum formula for quarters for a year and fill it
horizontally for each additional year. However the cell refrences only moves over one column, however I need it to move over 4 columns to sum correclty. Is there an easier way to do this than going back and manually fixing the refrence that sums up each quarter for a given year? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I fill a sum formula for for quarters into adjacent years
Try
=SUM(OFFSET($B$3,0,4*(COLUMN(A:A)-1),1,4)) Where B$3 is the cell with the 1st quarter of the 1st year "got2be_an_easier_way" wrote: I want to take the sum formula for quarters for a year and fill it horizontally for each additional year. However the cell refrences only moves over one column, however I need it to move over 4 columns to sum correclty. Is there an easier way to do this than going back and manually fixing the refrence that sums up each quarter for a given year? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sum quarters to years; predefined shift of ranges | Excel Discussion (Misc queries) | |||
| Fiscal quarters for two years... | Excel Worksheet Functions | |||
| Fill formulas into adjacent cells does not take formula only data | Excel Worksheet Functions | |||
| Fill cells if adjacent cell match criteria | Excel Discussion (Misc queries) | |||
| Show quarters and years on x axis of a chart | Charts and Charting in Excel | |||
Linear Mode
