The basics of adding numbers in Excel doesn’t even need a special function.
That said, we will look at just how simple Excel does make it with functions.
But more on that later…
This is done in the cell where you want to perform the calculation.
So, let’s look at adding two numbers in a cell.
Note that we have simply typed in ‘=1 + 1’ into cell A1.
This is enough to perform the operation and return the sum.
Now you know about the concept of how to add literal number values in a cell.
Let’s look at how easy it is to do the same with cell references.
Notice in this example that we have used the cell references for ‘C2’ and ‘C3’, each of which contain the value ‘2’.
As we would expect, our equation in ‘A2’(‘=C2 + C3’), returns the value ‘4’.
If there were more cells containing values we wanted to add to the equation, we could do the same thing we did with literal values before.
Of course, at some point, adding any more values to the equation becomes inefficient.