Comments (9)

Sep 4, 2013

do offset(source,0,((column($A$1)-column(A$1))*12), this means that every time you drag it one cell right it will be grabbing 12 cells right in the source.

Sep 4, 2013

Appreciate it

Sep 4, 2013

Well, still having trouble when dragging to the right.

Sep 4, 2013

What's the problem? Might have to make this in to an indirect.

Sep 4, 2013

Oh snap, switch the 12 to -12, that'll give you the right number.

Sep 4, 2013

When I drag it to the right it's just returning the next number over from the source. What should be my first number in there that you labeled "source"?

Sep 4, 2013

it should be the cell address of the first annual number you want to grab from the other sheet... a link to the #. then when you drag the formula right, for every cell to the right of that it should grab the next number in that other workbook 12 columns over..

Sep 4, 2013

What if I have semestral revenues, but I want to calculate yearly revenues in another tab.
I also need to drag a formula, but I couldn't find the right combination of offset.

It's basically the same exact problem as OP, but with two cells rather than 12.
Can someone help out?

Sep 4, 2013
Comment