exel question?

Question

hi , I have some numbers and I wanna add the first number to the second number , and the second to the third and so on , let me give you and example : I have three numbers 2,8,5,10
and I want the result to be 10,15,25
is there any function in excel for doing so?
tnx

Answer 1

Put each of your original numbers in a cell, for example, use row 1, first four cells (A1, B1, C1, D1) to place the numbers 2, 8, 5, 10.

Then in the next row, put the following formula in cell B2:
=SUM($A1..B1)

Right Click Cell B2 and click "Copy".

Select Cell C2, and all cells to the right of it. Just left click in Cell B3 and drag to the right. Drag as far as you want, the more cells you select, the more numbers your spreadsheet can handle.

When you have dragged as far as you want, press the Enter key. This will "paste" what you just "copied" from cell B2, but it will increment the reference to B1 as it pastes across. Click the cells in row 2 one at a time and you'll see they increment as you go across.

Now, all you have to do is put numbers in each cell of Row 1. The cell directly below each cell will represent the sum of that cell with all cells to it's left. For example, Cell F2 will contain the sum of Cells F1 + E1 + D1 + C1 + B1 + A1

Answer 2

Yes. You could go to an in-depth formula. You can also just use the "Auto-sum" function.
On an Excel spreadsheet, type in a vertical column:2,8,5,10. In a cell where you want the sum of any of the combination, click auto-sum. Then highlight the 2 that you want to be summed up. Click auto-sum again. Continue with all the ones that you want to add. It's easy.

Answer 3

The previous answers for function are all usable. You can also try the format tab, auto format, and then with the category indicate what you want to do. You can add either direction, either rows across or at the bottom of the column.

The book I have on hand at all times (and learn from it constantly is "Excel for Dummies". Very good and useful!

Answer 4

Depends on how you want the spreadsheet to look. You could do sub-totals and then add the next number.

So you'd put the 2 in one cell and the 8 in the next. Do a sum in the following cell. The next cell you would put the 5 and then have that add to the previous sub total. And so on and so forth. You could stagger cells to keep it clean looking. Ie. put the integers in column A and have the sub-totals land in column B.

Answer 5

Simple:
you can put the numbers 2,8,5,10... on the column A.
Then, on cell B2, you type: =sum($A$1:A2)

When you extend that value to the cells below B2, you'll always begin the sum with the first value (2, in this case). For example: in cell B3, you'll have =sum($A$1:A3).

Answer 6

That is an easy one
Say these are the cells with results

A1: 2____B1:
A2: 8____B2:10
A3: 5____B3:15
A4: 10___B4:25

First cell is different: in B2 Type: =(A1+A2)
This will add the 2 and 8 and display in B2
In B3 type: =(B2+A3)
This add the previous total in B2 (10) to the number in A3 (5)
In B4 type:=(B3+A4)
If you had more numbers, you would simple continue adding "1" each time to the cells
=(B4+A5)
=(B5+A6)
=(B6+A7).....

Answer 7

not really but if the numbers are in different cells you can simply use the add function from cell A1 and B1 and then add C1 to this number and then add D1 to the result and that should be it... hope it helps..

Answer 8

just click on the cell where you want the answer to be and find the side ways W (looks like a funny E) drag the mouse from the beginning cell to the last cell and hit enter

Answer 9

in the cell to show value 10 type this:
= (cellcontaing2)+(cellcontain8)
in the cell to show value 15 type this
=(cellcontaing2)+(cellcontaining8)+(cellcontaining5)

so...where the cellcontaing# are the actual cell locations such as =(b1+c1)

you can also click insert, then click function and click sum. then instead of typing the cell locations, you can drag and grab them.

hope this helps! gl

Answer 10

If they are in a separate column from each other, you can do a simple formula of =D9+D10 and just copy it all the way down, otherwise I really don't know.