=SUM(A1:INDEX(A1:A10000,D1))

change any cell references accordingly to fit your own requirements

--
Regards,

Peo Sjoblom




"Fran McConville" wrote in
message ...
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