Thread: Indicating how many cells to sum up

Hello,

Problem:

I want to tell excel to sum up 4 cells in a column. But I want to make the number of cells dynamic. In other words, I want to have a empty cell where I type 2 or 3 or 5, and according to what number I typed in that cell, excel goes to a given data and sums up however many cells i indicated on the above cell to sum up.

Illustration.

A1= 2
data is b1:b100
Since A1 is 2, I want excel to sum up b1:b2. But if A1=4, I want excel to sum up b1:b4.

THANK YOU

Hi Calhawk,

Perhaps try:

=SUM(OFFSET(B1,0,0,A1))

Thanks for editing your thread title, calhawk01,

another way is to use INDEX

=SUM(B1:INDEX(B:B,A1))

Hey now.. I'm a Mod too.. that hurts a little.

Just kidding, glad you have it sorted out.

Please mark the thread as Solved, thanks. (Click Edit in first post, click Go Advanced, select [SOLVED] from the "Title" drop-down where it says No Prefix, click Save Changes.)