| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Array formula on INDEX function not working
........A.........B 1.....1..........2 2.....3..........4 3.....7 4.....12 5.....13 To my surprise, {=SUM(INDEX(A1:A5;B1:B2))} returns 3, and not 15 (entered with Ctrl-Shift-Enter) Can anybody explain and give correct formula? Thank you |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Array formula with index + match | Excel Worksheet Functions | |||
| Incorporating INDEX function into Array Formula (CNTRL-SHIFT-ENTER | Excel Worksheet Functions | |||
| Returning an array from the INDEX function | Excel Worksheet Functions | |||
| Using INDEX function to return array row. | Excel Worksheet Functions | |||
| Index and Match Array formula | Excel Worksheet Functions | |||
Threaded Mode
