What is the mathematical equation in excel that adds a series of numbers?

Question

In other words, if I want to get the sum of x,x+1,x+2,x+3,x+n is there a simple way of doing it?

Answer 1

Well, the brute-force method is to create a column with those numbers and hit the "summation" button (which is a Greek sigma) on the toolbar.

But the simpler method is to use summation math, which will give you an equation for any such series no matter how long. in this case, the sum of the series would be:

sum = nx + {(n * [n+1]) / 2}

Answer 2

You will have to do some pasting, but here's what I would do.

1.) Put the value of x in cell a1

2.) Write the formula sum(a1+1) in cell a2

3.) Copy the formula from cell a2 into the rest of the column a - here is the time saver - make sure you paste it into all cells at the same time.

If you paste one cell at a time, you will paste the original formula, but if you paste into all the cells at the same time by selecting them all first, excel will know to up the cell number in each row to be the preceding cell number. a5 will reference a4 and so on if you paste as a group.

The result will be a quick way to enter all the numbers into the cells. a1 will have x, a2 will have x+1, a3 will have x+2 etc.,...

4.) Once you have the list populated, write a formula in any other cell as follows: sum(a1:aX) where X is the row that has the last number in your series.

Answer 3

Am I right in thinking you want to add a series of integers?

If I was doing this I would use the following functions
A1: Input your lower limit here (i.e. x)
B1: Input your upper limit here (i.e. x + n)

Now, using the fact that the sum of the first a natural numbers is a(a+1)/2, you should calculate the some of the first (x + n) natural numbers, minus the sum of the first (x - 1) natural numbers

C:
=(0.5*B1*(B1+1))-
(0.5*(B1-1)*B1)

[Note: The equation for C should be input as one line - it has been split up so it doesn't get truncated by yahoo]

Answer 4

If it is all the cells in a row / column you can use
=sum(A1:A22), or =sum(A1:G1),for example.

But remember to use the colon between the start point and end point, also remember the total includes both points.
Insert this formula in the cell you want to display the sum, which does not have to be near the cells being added.

Answer 5

Use the autosum characteristic. First placed the cursor in the cellular which you extremely want the answer to seem in. in the menu bar there's a logo that feels like a backwards E. click that button then spotlight all cells which you extremely want to characteristic up. Press enter and the excellent will seem in the cellular. Any alterations to the column will reason computerized alterations in the excellent displayed.

Answer 6

As a trial, in cell E7 type x,in cell F7 type x+1, in cell G7 type x + 2 and in cell H7 type x+3. These are headings only.
In cell F8 type = E8 + 1. Drag this formula to the right into cells G8 and H8.
Input any number into E8 and answers to x + 1,x+2 and x+3 will appear in cells F8,G8 and H8
Can then extend table as required.

Answer 7

Make sure all the numbers you want to add up are in a column. Click on fx key at top on toolbar. Then Click on sum. It will bring up a box asking you to enter the range of numbers to add up.

Answer 8

Use the sum function. You can either type it in as:

=sum(a1,b2,c17)

or you can use the backwards E looking thing in your toolbar. Click on that button, then select all the cells you want included in the sum.

Answer 9

I think you just type in the equals sign and then type in the letter of the cells that you want to add up for example =SUM (A1+B1+C1) and then just press Enter.

Answer 10

use the help function