# Fixed Rows Variable Column in SUMPRODUCT formula

#### Mokk817

##### New Member
I've been searching for a long time and can't seem to come up with the correct adaptation to my formula so any help is much appreciated.

Basically I'm using sumproduct to multiply data in columns on two different sheets.

=SUMPRODUCT((\$N\$2:\$N\$244)*('GAMES MATRIX'!B\$2:B\$244))

The formula works fine but my issue is I need to drag this formula down and get the columns to advance, essentially looking like this:

=SUMPRODUCT((\$N\$2:\$N\$244)*('GAMES MATRIX'!C\$2:C\$244))
=SUMPRODUCT((\$N\$2:\$N\$244)*('GAMES MATRIX'!D\$2:D\$244))
=SUMPRODUCT((\$N\$2:\$N\$244)*('GAMES MATRIX'!E\$2:E\$244))

I have tried different variations of INDEX and ROW formulas but can't get anything to work correctly.

Again any advice is much appreciated.

### Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.
Assuming the first formula in A2 (adjust to suit) maybe something like this

A2
=SUMPRODUCT((\$N\$2:\$N\$244)*(INDEX('GAMES MATRIX'!\$C\$2:\$Z\$244,0,ROWS(A\$2:A2))))

copy down as needed

Hope this helps

M.

Absolutely brilliant!!!

Thanks so much Marcelo!!

Absolutely brilliant!!!

Thanks so much Marcelo!!

You are very welcome. Thanks for the feedback.

M.

Replies
3
Views
301
Replies
8
Views
367
Replies
8
Views
270
Replies
1
Views
153
Replies
4
Views
250

1,219,918
Messages
6,150,969
Members
450,996
Latest member
CXsjr

### 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