sum a column when the number of cells is variable

[anon125]

i will have a column of numbers.
i wish to sum them BUT, how many i choose to sum depends on an entirely different cell,
so if that cell says 12, then i need to sum the first 12. if it says 60 then i sum the first 60.
i tried using sum with indirect and concatenate from an online formula - got nonsense!
i use an ancient version but it does have these indirect etc things.
Thanks for your kind help

 

[Michael M]

How about

Book1
	A	B	C
1	2		1
2			3
3			4
4			5
5			6
6			1
7			2
8			3
9			4
10			5
11
12
13			4
Sheet1

Cell Formulas
Range	Formula
C13	C13	=SUM(OFFSET($C$1,0,0,A1))

 

[awoohaw]

Another possibility is

=Sum(C1: INDEX(C1:C5000,A1,1))

 

[anon125]

WOW!! thanks guys

 

[Fluff]

@anon125 please do not ask members here to help you on another site.

 

[anon125]

of the few who do not know... just click the green writing to go to that forum
thanks all

 

[Fluff]

There is no "green writing" as I removed the link.
Please see post#5

 

[anon125]

UHOH
thanks