can't add rows of data dictate by a number in a cell

**mdrx7** · 06-07-2010, 09:11 PM

Hello everyone. I am new to the forum and hope someone can help me with this. I am trying to add multiple rows of data base on a number I put in a cell. For example, in cell C1(this is where I put the number of rows I want to add), I put 2. In Cell B1, it will add Cell A1+A2. If I change the number in C1 to let's say 3, in Cell B1, it will add Cell A1+A2+A3. I tried to look up formulas in excel but was unsuccessful. I assume I have to write some VBA (which I am a newbie to this). Greatly appreciated to anyone that can help. Thanks.

**shg** · 06-07-2010, 09:57 PM

In B1, =SUM(A1:INDEX(A:A, C1))

**spreadcore** · 06-07-2010, 09:58 PM

Sorry I miss read your post, ignore this answer

If this is what you are wanting to do.

In Cell A1 put a 1
In Cell A2 put this formula

Please Login or Register  to view this content.

Now copy the formula down as far as you need it.

Now when you put a number in Cell C1 it will fill down from the number 1 to whatever number is in cell C1.
Example:
C1 = 5
you'll get this in column A
1
2
3
4
5

**mdrx7** · 06-08-2010, 11:31 AM

Originally Posted by shg

In B1, =SUM(A1:INDEX(A:A, C1))

Thanks for all the help guys. Greatly appreciated. Shg, I tried to use your formula, it works for the first Cell B1 for the solution, however, if I want to continue down the column B correspond to the data on column A, it spits out some funny answer. Example. I have Cell A1 = 1, A2 = 2, A3 = 3, and Cell C1 = 2(this is the formula you have given me). Now B1 = 3 which is correct. Now I want the same formula in B2 and I copy and paste (I also freeze cell C1), but now my answer in B2 = 2 which should be 5 (A2 + A3 = 5). Thanks guys again for looking into this for me. Appreciate all the help

**mdrx7** · 06-10-2010, 11:31 AM

Any suggestions?

**shg** · 06-12-2010, 05:49 PM

=SUM(A$1:INDEX(A:A, C1))

If that doen't work, post a workbook with manual examples.

**mdrx7** · 06-14-2010, 06:43 PM

Originally Posted by shg

=SUM(A$1:INDEX(A:A, C1))

If that doen't work, post a workbook with manual examples.

Shg, Thanks for your reply. I tried what you suggested but it's still doing the same. I have attached a example spreadsheet to illustrate what I am trying to do. Thanks again for your help.