Zero problem
 

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 the formula is correct, it relates to
each months totals, but returns a zero amount.

What is wrong?

Thank you
John

Zero problem
 

Would you like to post a copy of the formula you are using. Highlight the
entire formula in the formula bar and copy then press Enter then paste into
here.

Regards,

OssieMac

"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 the formula is correct, it relates to
each months totals, but returns a zero amount.

What is wrong?

Thank you
John

Zero problem
 

Did you try the solution I posted to the same post in excel.setup news group
with subject of "Problem"?

If so, what were the results?


Gord Dibben MS Excel MVP

On Tue, 16 Oct 2007 02:17: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 the formula is correct, it relates to
each months totals, but returns a zero amount.

What is wrong?

Thank you
John

Zero problem
 

Sorry for cross posting, but it seemed like this news group was more active
than the other one!
No results! (see other news group)
John

"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
: Did you try the solution I posted to the same post in excel.setup news
group
: with subject of "Problem"?
:
: If so, what were the results?
:
:
: Gord Dibben MS Excel MVP
:
: On Tue, 16 Oct 2007 02:17: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 the formula is correct, it relates to
: each months totals, but returns a zero amount.
:
: What is wrong?
:
: Thank you
: John
:
: