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

=SUMPRODUCT(array1,array2)

For example, you could use...

=SUMPRODUCT(OFFSET(cell1,,,3,),OFFSET(cell2,,,3,))

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

Raoul