Question: how to automatically subtract one column from another in excel?
Answer: Type a number in cells C1 and D1. For example, a 5 and a 3.
In cell E1, type an equal sign (=) to start the formula.
After the equal sign, type C1-D1.
Press RETURN . If you used the example numbers, the result is 2. Notes: