How to change step in formula

[Guest]

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!

 

[David Biddulph]

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.

 

[Guest]

It makes the problem about A$1,6 in the formula below

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

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!

 

[David Biddulph]

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

It makes the problem about A$1,6 in the formula below

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

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!

 

[Roger Govier]

Hi

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

 

[Guest]

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.

It makes the problem about A$1,6 in the formula below

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

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!

 

[Guest]

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.

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

It makes the problem about A$1,6 in the formula below

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

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!

 

[Guest]

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

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!

 

[RagDyeR]

Try this:

=INDEX(Sheet2!$AJ:$AJ,6*COLUMNS($A:A)+1)+INDEX(Sheet3!$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!
=====================================================

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

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!