Скачать или смотреть How To Subtract Multiple Cells (From A Cell) In Excel Explained

In this video we discuss how to subtract multiple cells from a cell in excel. We go through a detailed example showing the process step by step, and you can get negative results.

Transcript/notes
Let’s say that you need to subtract multiple cells from one another, such as in this example worksheet, where we want to subtract cells A4 and A5 from cell A3.

To do this, start by left clicking on the answer cell, here, cell A6, so it is highlighted, then we type in the equals sign. Next we left click on the cell we are subtracting from, in this case cell a3, then we type in a minus sign, next, we left click on the first cell we are subtracting, cell a4, then we type in another minus sign. And then we left click on the next cell we are subtracting, cell a5. Next we finish by hitting enter and we get an answer of negative 66.