Typically this is caused by the numbers being text and not real numbers.

Format all to General then copy an empty unused cell.

Select to range of numbers and EditPaste Special(in place)AddEsc.


Gord Dibben MS Excel MVP

On Tue, 16 Oct 2007 00:25:09 GMT, "VK2KCE" wrote:

Hello all, I wonder if anyone can help me? Please?

I have a spreadsheet and its a month by month expense sheet for a local
club.

Problem is that when I try to add all the months total expenses, i.e.
January, February etc, the total of each month at the bottom of the sheet is
0.00.

I have checked all the formulae and its correct, it relates to each months
totals.

What is wrong?

Thank you
John