Just enter the credit as a negative number. Then it will add up properly.

Regards,
Fred.

"Maurice" wrote in message
...
I share utilities and have a spreadsheet that divides each bill by four,
adds
the column for my total. There are times when a credit appears. I would
want each cell to take that into account as well so that overpayment is
divided by four and subtracted from the total. Is there a way for a cell
to
take either circumstance into account and calculate the appropriate value?
Guidance sought.