Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hi all,
Given this data (from the Excel help) In range A1:C11 Fruit Price Count Apples 0.69 40 Bananas 0.34 38 Lemons 0.55 15 Oranges 0.25 25 Pears 0.59 40 Almonds 2.80 10 Cashews 3.55 16 Peanuts 1.25 20 Walnuts 1.75 12 =SUM(INDEX(A1:C11;0;3;1)) returns 216 and the explanation is that this is the sum of C1:C6. For me, the sum of C1:C6 is 158! What is there behind that I don't see? Wkr, JP |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Using INDIRECT Function and INDEX Function | Excel Discussion (Misc queries) | |||
Index function | Excel Discussion (Misc queries) | |||
Index Function/Match Function | Excel Discussion (Misc queries) | |||
If function using Index | Excel Worksheet Functions | |||
Emulate Index/Match combo function w/ VBA custom function | Excel Worksheet Functions |