K
kayard
Hi,
I'm slightly puzzled.
Can anybody explain me why the following formula works as expected
(returns 320) :
=SUMPRODUCT(INDEX(Sheet2!B2
6;C6;0);INDEX(sheet3!B2
6;C6;0))
BUT, if I put in cell H1 (for example)
INDEX(Sheet2!B2
6;C6;0) and
INDEX(sheet3!B2
6;C6;0) in H2
and then
SUMPRODUCT( H1;2) this doesn't work as expected ?
NB: I paid attention to enter formula in H1 and H2 as matrix (CTRL +
SHIFT + ENTER) ...
Any guess ?
I'm slightly puzzled.
Can anybody explain me why the following formula works as expected
(returns 320) :
=SUMPRODUCT(INDEX(Sheet2!B2
![Big Grin :D :D](/styles/default/custom/smilies/grin.gif)
![Big Grin :D :D](/styles/default/custom/smilies/grin.gif)
BUT, if I put in cell H1 (for example)
INDEX(Sheet2!B2
![Big Grin :D :D](/styles/default/custom/smilies/grin.gif)
INDEX(sheet3!B2
![Big Grin :D :D](/styles/default/custom/smilies/grin.gif)
and then
SUMPRODUCT( H1;2) this doesn't work as expected ?
NB: I paid attention to enter formula in H1 and H2 as matrix (CTRL +
SHIFT + ENTER) ...
Any guess ?