Sum subrange of named range

[JuliuszGonera]

Hi,

I have a named column range payments. I’d like to sum say the first six values of that range, how can i do that?

The INDEX function does almost what i need, unfortunately it returns only one value instead of some subrange of the named range

[JuliuszGonera]

Managed to find the answer myself:

=SUM(OFFSET(payments,0,0,12,1))

[Lupp]

You are summing the first 12 elements here which are double the number you intended.