Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi all,
Hopefully someone can help me solve this issue: Suppose I have quarterly data for several years in a single row. Then it is simple to sum the quarters of the first year to get a year's result. If I then copy this cell one position to the right, the result is Q2 + Q3 + Q4 + Q1 of the next year. Question: how do I copy a cell one position to the right, but at the same time move 4 positions in the source row? And the next cell: position + another 4, and again, and again, to get full year's results. Can this be done? Cheers, Goose |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Fiscal quarters for two years... | Excel Worksheet Functions | |||
Overlay 4 years of data as a line on 4 years of columns for several x category labels | Charts and Charting in Excel | |||
[Shift] + [Arrow] key usage with chart ranges | Excel Worksheet Functions | |||
designing and saving predefined pivot table formats? | Excel Worksheet Functions | |||
Show quarters and years on x axis of a chart | Charts and Charting in Excel |