Simple Addition Formula in Excel

Are you trying to figure out how to set up addition  formulas in Excel? Maybe you are trying to set up a user-friendly budget or trying to keep track of an event coming up. 

These super easy formulas will help you accomplish just that.

First, you can type in =SUM to begin this formula 

or you can click the fx next to the address bar.

Next, we begin by either typing in the cells we would like to add together.

Make sure when you are finished adding all cells together, you add the closed parenthesis at the end. If you do not do this, you will receive an error.

For this particular formula, it will look like this once completed.

=SUM(A2:B2)

Let's say you are wanting to only add particular cells together, not wanting to include some.

You can do that this way:

I manually typed in =SUM( then clicked on the cells I wanted to add making sure to put a + between each cell.

If you were wanting to subtract the cells, you could put a - between each cell.

In this one, I added the first 2 cells and subtracted the 3rd cell. You can add or subtract in any order.

When you are finished, hit ENTER. Your formula is now complete!