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