The SUM Function in Excel

The SUM Function in Excel
In earlier parts of this course, you used addition formula quite a lot. You saw that the basic way to add things up was by doing this:
=A1 + B1 + C1
You've also used the in-built SUM function:
=SUM(A1:C1)
Whichever of these two you used, the answer was the same - Excel will add up whatever numbers you have in the cells A1, B1, and C1. The two methods above are adding up consecutive cells. But what if you want to add up the following, non-consecutive cells: A1, B1, C1, D9?


View Docs