N,

The general idea is to tie your offset to the column of the formula - for
example, if your first formula is in cell E2:

=SUMIF(OFFSET('[Book3.xls]Line Returns
(Internal)'!$E$4:$E$300,0,(COLUMN()-COLUMN($E$2))*5), CONCATENATE(LEFT(C$3,
2),$A6),OFFSET('[Book3.xls]Line Returns
(Internal)'!$B$4:$B$300,0,(COLUMN()-COLUMN($E$2))*5))

Then copy to the right, and it should work...

HTH,
Bernie
MS Excel MVP



wrote in message
ups.com...
I want to copy formulas horizontally and in the formula, it want it to
skip 5 columns and then calculate. Is there a way to do this?

For example, in one cell I have

=SUMIF('[Book3.xls]Line Returns (Internal)'!$E$4:$E$300,
CONCATENATE(LEFT(C$3, 2),$A6),'[Book3.xls]Line Returns (Internal)'!$B
$4:$B$300

in the next adjacent cell, I have

=SUMIF('[Book3.xls]Line Returns (Internal)'!$J$4:$J$300,
CONCATENATE(LEFT(C$3, 2),$A6),'[Book3.xls]Line Returns (Internal)'!$G
$4:$G$300)

So i want to copy formulas skipping 5 columns in the exterior workbook
(book 3). I would appreciate if anyone has some good solutions.


Thanks in advance