G
Guest
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
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