to our formula means that Excel will create a cell reference that starts in column B, and then minuses 1 from the value in E1. Finally, we want to reference cell B6, ...

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.