| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
strange behaviour with matrix formulas
Hi, I'm slightly puzzled. Can anybody explain me why the following formula works as expected (returns 320) : =SUMPRODUCT(INDEX(Sheet2!B2:D6;C6;0);INDEX(sheet3! B2:D6;C6;0)) BUT, if I put in cell H1 (for example) INDEX(Sheet2!B2:D6;C6;0) and INDEX(sheet3!B2:D6;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 ? -- kayard ------------------------------------------------------------------------ kayard's Profile: http://www.excelforum.com/member.php...o&userid=24716 View this thread: http://www.excelforum.com/showthread...hreadid=542448 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Strange behaviour when sorting rows | Excel Discussion (Misc queries) | |||
| Unexpected (?) behaviour of OFFSET() in array formulas | Excel Discussion (Misc queries) | |||
| Strange "FormatCells" behaviour | Excel Worksheet Functions | |||
| Help, Urgent Excel Formulas are not calculating | Excel Discussion (Misc queries) | |||
| Strange behaviour | Excel Worksheet Functions | |||
Threaded Mode
