How Many Ways Can You Add Cells Together? Part I

This will be a three part series, covering different ways to add cells together.

Today: The good ol'e addition sign, and the sum formula.

Addition:

The most elementary of ways to add cells together, but the core of many spreadsheets, the + symbol. Quite simple, your formula is =B1 + B2. In my example, the formula is in B3.





Alternatively, you can use the sum formula to accomplish the same task. There are two manners in which you can use the sum fomula. You can reference individual cells, and ranges.



Sum formula Example 1: Individual Cells

In cell B3, I've typed =sum(B1,B2)





Sum Formula Example 2: Cell ranges

In cell B3, I've typed =sum(B1:B2)



Sum Formula Example 3: Individual Cells and Cell Ranges

In Cell B5, I've typed =sum(B1:B2,B4)



As you can see, there are lots of ways to accomplish the same task. Part II of this series will cover the sumif formula with one criteria, and part III of this series will cover how to accomplish the sumif formula with multiple critiera.