Awsome, i was so close, had the b1 in the wrong sequence. works great now!!!

Thanks MAX

"Max" wrote:

Just set the OFFSET's height param to point to B1, viz:
In say, C1: =SUM(OFFSET(A1,,,B1))
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"T5s" wrote:
Hello, i have a situation that i thought would be pretty simple, and i'm sure
it is for you guru's. Basically if i have a column of 30 numbers i want to
be able to state that i want to sum the first 10 numbers in the column.

A B
10 2
20
20
20
40
50

I want to use the number in B1 as a variable and sum the first 2 rows in
column A yeilding a total of 30. Then if i need to change B1 to 3 i would
get 50 etc etc.

I've gotten close with the offset function, but that works just the
opposite. so any and all help would be great!

thansk
Tim