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.