How to skip rows when dragging a formula

**casparschwa** · 10-01-2016, 02:30 PM

Hi everyone,

I want to drag down a formula that skips 4 rows.

My formula is:

SUMPRODUCT(--(W23:ID23=N46),--(X23:IE23=O46),(W26:ID26))

and I want to drag it down so that it in the row below it becomes:

SUMPRODUCT(--(W27:ID27=N47),--(X27:IE27=O47),(W27:ID30)).

As you can see I want some part of the formula to skip 4 rows and some just to the next row (as is normal).

Thank you so much for your help!!

**protonLeah** · 10-01-2016, 03:34 PM

if starting in row one:

Please Login or Register  to view this content.

**casparschwa** · 10-01-2016, 04:00 PM

Originally Posted by protonLeah

if starting in row one:

Please Login or Register  to view this content.

Thanks, but unfortunately I am still confused... Also, I am not starting in row one.
In this file you can see the pattern I am trying to get: Go to the Sheet called "Selected Data Set" and see cells X44:Y47 to see what I am trying to do.

Schachdatenbank + Tullock.xlsx

Thank you so much. Help is much appreciated!

**protonLeah** · 10-02-2016, 06:00 PM

Maybe:

Please Login or Register  to view this content.

How to skip rows when dragging a formula

LinkBack

Thread Tools

Rate This Thread

Display

How to skip rows when dragging a formula

Re: How to skip rows when dragging a formula

Re: How to skip rows when dragging a formula

Re: How to skip rows when dragging a formula

Thread Information

Users Browsing this Thread

Similar Threads

Dragging a formula that increases in count, but doesn't skip

[SOLVED] How to skip columns whilst dragging a formula

skip 1 cell when dragging down formula

How do you skip a row when auto dragging a formula?

How to skip a cell reference while dragging down a Hlookup formula

[SOLVED] Skip column when dragging formula.

Skip every other line while dragging formula

Bookmarks

Bookmarks

Posting Permissions