Assuming that A2:A100 contains the data, and C2 contains n, try...

=SUM(A2:INDEX(A2:A100,C2))

Hope this helps!

In article ,
Fran McConville wrote:

I'd simply like to sum the first n values in a column or row, where the value
of n is in a separate cell. ie if I enter '3', it will sum only the first
three values in the range, if I enter '8' it will return the sum of the first
8 values in the range. TIA for any help