Question: how to subtract sum of several cells from fixed number?
Answer: Place the cursor in the subtraction number position (cell B1)
Do a copy (CTRL+C)
Make a range A1:A10, containing the numbers that will be subtracted.
Do a paste special (CTRL+ALT+V)
Select “Subtract” in the Operation section.
Click the OK button.