How to change step in formula
 

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!

How to change step in formula
 

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!

How to change step in formula
 

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!

How to change step in formula
 

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!

How to change step in formula
 

Hi

One way
=INDEX(Sheet2!A:A,(ROW(A1)-1)*6+1)+INDEX(Sheet3!A:A,(ROW(A1)-1)*6+1)
and copy down

--
Regards

Roger Govier


"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!

How to change step in formula
 

Here you go, try this on:

=INDIRECT("Sheet2!A" & 6*ROW()-5)+INDIRECT("Sheet3!A" & 6*ROW()-5)
--
-John Northwest11
Please rate when your question is answered to help us and others know what
is helpful.


"Shvraka" wrote:

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!

How to change step in formula
 

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!

How to change step in formula
 

This one helped a little bit but I really do not understand the concept so if
you could help me a little bit mo

if I want in cell E4 to have first of these formulas F4 second etc.. and to
take data from cell AJ7, AJ13, AJ19 etc... in Sheet 2 + same cells in Sheet 3
how would the formula look like then?

Thanks in advance!



"Roger Govier" wrote:

Hi

One way
=INDEX(Sheet2!A:A,(ROW(A1)-1)*6+1)+INDEX(Sheet3!A:A,(ROW(A1)-1)*6+1)
and copy down

--
Regards

Roger Govier

How to change step in formula
 

Try this:

=INDEX(Sheet2!$AJ:$AJ,6*COLUMNS($A:A)+1)+INDEX(She et3!$AJ:$AJ,6*COLUMNS($A:A)+1)

And copy *across* as needed.
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"Shvraka" wrote in message
...
This one helped a little bit but I really do not understand the concept so
if
you could help me a little bit mo

if I want in cell E4 to have first of these formulas F4 second etc.. and to
take data from cell AJ7, AJ13, AJ19 etc... in Sheet 2 + same cells in Sheet
3
how would the formula look like then?

Thanks in advance!



"Roger Govier" wrote:

Hi

One way
=INDEX(Sheet2!A:A,(ROW(A1)-1)*6+1)+INDEX(Sheet3!A:A,(ROW(A1)-1)*6+1)
and copy down

--
Regards

Roger Govier