I'd say it was a typo in help.

I wonder if they meant:

=SUM(INDEX((A1:C6,A8:C11),0,3,1))

(I use commas as my list separator. You'll have to change them.)



JP Ronse wrote:

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

--

Dave Peterson