OK it was with semi-colon, but that did not solve my problem. Let my simplify:

Type in cell A1 =B1
Type in cell A2 =B5
Type in cell A3 =B9

than select those 3 and drag fill handle

I want to get in the A 4 =B13 following logic B9+4=B13
in A5 =B17
etc...

But it fills

A4 =B4 ????????????

A5 =B8 ????????????

A6 =B12 ?????

How to change the step that excell follows

If you type numbers 1,5,9 and do the same it does fill cells below with 13,
17, 21 etc... but when you do that with cell refference it wont do right.



"David Biddulph" wrote:

I don't understand what you are saying. What error message do you get?
Are you working with settings in which the separation character is a
semi-colon rather than a comma? If so, change my commas to semi-colons.
--
David Biddulph

"Shvraka" wrote in message
...
It makes the problem about A$1,6 in the formula below

"David Biddulph" wrote:

You could try
=OFFSET(Sheet2!A$1,6*(ROW()-1),0)+OFFSET(Sheet3!A$1,6*(ROW()-1),0) if
your
first formula is in row 1. [If it's in a different row, change the two
occurrences of -1 to refer to the relevant row.]
Copy that down.
--
David Biddulph

"Shvraka" wrote in message
...
I would like to apply this formula to several cells in sheet:

=Sheet2!A1+Sheet3!A1

When I copy this formula to the next cell below it I would like it to
show:
=Sheet2!A7+Sheet3!A7

next cell would be:

=Sheet2!A13+Sheet3!A13

BUT when i drag the fill handle it does not follow the step (6) I gave
it
to
follow?!

Thanks!