What is the addition formula for Excel spreadsheets?

Answer 1

Simple addition can be done using the + sign:

=A3 + A5

The formula for doing addition in Microsoft Excel can use the SUM function.

=SUM(A3+A15)

You click on the box you want the sum to appear in. In that box you type=SUM( then you write the boxes you want to add up. ex: B1,C1,D1. make sure you put a comma between each box number

ex:=SUM(B1,A1,C1)

To do a block of cells you can use a range reference. To sum all the cells from A2 to A15, you would use a colon in between them:

=SUM(A2:A15)

Answer 2

There are several ways to add in Excel. What way you use may depend on what you are adding and how many things you are adding. You can use the plus sign or the Sum function. You can use the plus sign when you only have a few values to add. So if you were just adding the values in cell A1 and A2, then you could do this:

=A1+A2

If you were adding all the values in the cells from A1 to A10 you could do it

=A1+A2+A3+A4+A5+A6+A7+A8+A9+A10

That is quite long, so it is simpler to use the Sum function. You would do it this way:

=Sum(A1:A10)

You will get the same answer, but that is more efficient and simpler.

You will sometimes see people doing something like:

=Sum(A1+A2)

In that case, the Sum is not needed, as you can see from the first example I gave.