Excel - How to subtract a Fixed number from each cell separately and then sum the results in one cell ? : Am trying to subtract a fixed number from all cells in column separately, and then sum the result in one cell, i want all this function in one cell, its easy to do it each one alone but i want to mix it in one cell.


here is my example: I want my fixed number (300) to be subtracted from each cell in column **A** and then sum the results from them in one cell (**B1**) = 530

        **A**               **B**

**1**    200                  530

**2**    300

**3**    70

**4**    100