How to sum multiple rows in excel
You can watch a video tutorial here.
![](https://spreadcheaters.com/wp-content/uploads/Final-Image-4-1.jpg)
Addition is one of the most basic commands when using spreadsheets. Most commands start from addition of columns but this article will focus on summing up rows.
Step 1 – On an empty cell, type in SUM followed by the cells you want to be added.
![](https://spreadcheaters.com/wp-content/uploads/Step-1-5-1.jpg)
The SUM command will automatically add all the chosen cells. In this example, cells B1 and B2 are chosen. Summing up more than 2 cells can also be done and the same process is followed.
Step 2 – Press Enter
![](https://spreadcheaters.com/wp-content/uploads/Step-2-4-1.jpg)
By pressing Enter, the result will be shown.