Hi,
Type this formula in a desired cell, say C2, to get the result you want:

=SUM(OFFSET(A2,0,0,B2,1))

This assumes that your data to be sumed starts from cell A2.

If you want to copy the formula to many cells, convert A2 to $A$2 and B2 to
$B$2.

Viral Sheth

"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