Add or Subtract Multiple Cells in Excel

Excel usually allows you to do different calculations in a few different ways. It’s also the case if you want to do simple arithmetic operations such as addition or subtraction.

Take a look at the following example.

Let’s add and subtract numbers in column A (A2:A5) to the value in cell C2. The most straightforward way is to add and subtract these numbers one by one.

But, it’s not the most elegant way. If you have a lot of numbers, the better idea is to use the SUM function.

Let’s change the formula.

It will return the same result, but the notation is much simpler, faster to write, and it’s harder to make a mistake.

Tomasz Decker is an Excel specialist, skilled in data analysis and financial modeling.