C
CTB
Hello all,
I need a sumproduct formula that will transpose as I copy across
columns. I have tried:
=SUMPRODUCT(OFFSET(Balances!$G$9,RowOffset,0,1,2),OFFSET(Rates!$G
$9,RowOffset,0,1,2))
(FYI: RowOffset is a named range: =COLUMN()-5 )
It doesn't seem like sumproduct likes to play with offset. It appears
the offsets are returning the right ranges, but trying to use offsets
with sumproduct no workie.
I need a sumproduct formula that will transpose as I copy across
columns. I have tried:
=SUMPRODUCT(OFFSET(Balances!$G$9,RowOffset,0,1,2),OFFSET(Rates!$G
$9,RowOffset,0,1,2))
(FYI: RowOffset is a named range: =COLUMN()-5 )
It doesn't seem like sumproduct likes to play with offset. It appears
the offsets are returning the right ranges, but trying to use offsets
with sumproduct no workie.