Hi Mike

The cell which has the formula in, is it General formatting and not as a date!

Hi Kevin, thank you for reading this.

I think it is general formatting.

Columns "A" to "G" are on the income side, with "A" being
the Date and G being the total, "B" to "F" are the income
streams.

Te formula =SUM(B4:F4) is in the "G" column, but it is not
doing the job.

There must be some hidden text or instructions in that cell
I think.

If all fails, I will just have to start with a fresh spreadsheet,
I tried to help myself by using an old one, but deleted all the
formula in the cells, so a fresh sheet will be clean.

Mike.