MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Offset command and sumproduct/ arrays

Posted by Raoul on January 29, 2002 10:52 AM

Does anyone know if the OFFSET command can be used either within a SUMPRODUCT formula or an array calculation?

Many thanks for any help

PS Thanks too for the previous filings on arrays, I have recently built my first working formula and it looks beautiful - in a geeky kind of way!!

Posted by Mark W. on January 29, 2002 11:59 AM

Yes, instead of...


For example, you could use...

=SUMPRODUCT(OFFSET(cell1,,,3,),OFFSET(cell2,,,3,)) long as the arrays produced by OFFSET have
the same dimensions.

Posted by Aladin Akyurek on January 29, 2002 3:27 PM



Posted by Raoul on January 30, 2002 2:36 AM

Thanks for that (and Aladins comments), I had tried to insert the range, instead of using the 'Range Height' variable in the Offset command.