I am trying to make a column product negative numbers when I manually enter
them in a spreadsheet. I am using a simple sum formula to add across rows
(10 columns) and the first column should always be a negative number i.e
credit and the rest positive.

I am real new to excel so I must be doing something wrong.