How do you reverse the sign of a range of numbers in Excel?

Excel lets you apply a multiplication against a range of numbers via the Paste Special function.

To reverse the sign, this is equivalent to a multiplication by -1. Therefore:

1. Enter -1 into any free field
2. highlight it and copy
3. Select the range you want to change the sign of
4. Right click, point to paste special and choose Paste Special
5. In the new dialog Paste All and apply Operation Multiplication
6. OK - all numbers have their sign changed.

this is what the formula looks like =(SUM(J120:J202))*-1 replace the cells with yours in your spreadsheet