In Microsoft Excel I want to sum each number from column A with another number.
The line I used looks like this: =SUM(A2,-400)
How do you make it automatically do that for the entire column without placing =SUM(A3,-400), SUM(A4,-400), etc. in each column?