Subarray - easy question

[pty1196]

Suppose I define a name: table1 to reference cells: A1:A10.

I would like to use syntax: sum(table1[2..5]) to get a sum of all numbers in table1 from 2nd element to 5th element.
How to do this in excel 2010?

Thanks.

[:) Sixthsense :)]

I believe you have to reference it as normal range reference like Sum(A2:A5)

[Andy Pope]

whilst you can not use structured references to get specific rows you can in INDEX

=SUM(INDEX(Table1[Value],2,1):INDEX(Table1[Value],5,1))