You’ve probably used SUM a thousand times. Everyone has. SUM is fine for school assignments and tiny tables, but in the real ...

In our case, we have to sum the data in the cells B2 to B6, hence, the formula is: =B2+B3+B4+B5+B6. Similarly, you can create a formula to subtract data in Excel.