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