Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 : : |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Started out as an Access problem. Now an Excel problem | Excel Discussion (Misc queries) | |||
problem with a conditional max problem | Excel Discussion (Misc queries) |