# Drag and fill question

#### kwg881

##### New Member
Hi, I am having a problem with Dragging and filling. I would like my cells to fill sequentially when I drag but I seem to have an issue.

In cell B1 and each row down I would like the equation to look like this over the next 100 cells
=A1+A3
=A2+A5
=A3+A7...and so on

But when I drag fill over the next 100 cells the autofill does
=A1+A3
=A2+A5
=A4+A7
=A5+A7
=A6+A9
=A7+A9

Why does the second value seem to double up and not go by the increment of 2 as I would like? Thank you for any insight. Hopefully an easy solution because this is acutally part of a quite large IF statement and it is driving me batty.

Kris.

### Excel Facts

Create a Pivot Table on a Map
If your data has zip codes, postal codes, or city names, select the data and use Insert, 3D Map. (Found to right of chart icons).

#### Jonmo1

##### MrExcel MVP
Hopefully an easy solution because this is acutally part of a quite large IF statement and it is driving me batty.

Kris.

You're best off posting your actual formula, and post a few examples of how you expect the references to change as you fill down.
Any solution provided for your simplified version will most likely not work for your real situation.
So we'll spend more time trying to "adjust" the simple solution to apply to your real situation.

It doesn't work because filling formulas can really only incriment references by 1 row or column at a time.
It's "Trying" to do it's best to do what it "thinks" you want..
But of course we know a computer can't "try" or "think" very well...

It just doesn't work that way.

#### kwg881

##### New Member
Oh no, Now there is pressure to show what I think is a long IF statement Just remember that I am no excel expert, thus all the what are probably simple questions I ask.

My actual equations are:

I would like to drag fill over the next 100 or so cells with this pattern.

Thank you.

Kris.

#### Jonmo1

##### MrExcel MVP
Try

Don't change the A\$1:A1 parts, it has nothing to do with your data.

Replies
7
Views
237
Replies
2
Views
212
Replies
5
Views
100
Replies
15
Views
262
Replies
13
Views
343

1,196,016
Messages
6,012,865
Members
441,737
Latest member
bijayche

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back