Excel sum of sums = 0
Solved
elyote
Posted messages
59
Status
Membre
-
elyote Posted messages 59 Status Membre -
elyote Posted messages 59 Status Membre -
Hello,
I am on Windows XP SP3, with Office 2007 Professional installed.
I have a problem with an Excel file; I'm unable to perform a sum of sums.
The error is that the result always gives zero.
The cell formatting is set to "Number".
Where can I upload the Excel file in question so that someone can help me?
Thank you in advance
I am on Windows XP SP3, with Office 2007 Professional installed.
I have a problem with an Excel file; I'm unable to perform a sum of sums.
The error is that the result always gives zero.
The cell formatting is set to "Number".
Where can I upload the Excel file in question so that someone can help me?
Thank you in advance
Configuration: Windows XP Firefox 3.0.14
8 réponses
Good evening,
Indeed, given the issue:
Actually, there is a circular reference problem in the workbook (I don't know if there are several, but there is one in D18 of this marketing tab: I found this formula in D18...: =($D$18/12)*C18). A circular reference is when a cell refers to itself, either directly or, more often, through a loop of formulas in different cells.
These circular references are possible in Excel for iterative calculations.
Two scenarios:
either this circular reference is an error: to be corrected.
or it is intentional (the case of iterative calculation) and in that case, you need to go to Excel options under the formula submenu and check the box "enable iterative calculation." You have the option to define the number of iterations and/or the precision of the calculation to be performed ("maximum deviation").
In your workbook, allowing for this iterative calculation obviously gives a result at the level of the desired formulas, but it is up to you to analyze your tables to determine whether these references are errors or not.
To perform this analysis, Excel offers auditing tools.
--
If you need anything, just ask me.
Indeed, given the issue:
Actually, there is a circular reference problem in the workbook (I don't know if there are several, but there is one in D18 of this marketing tab: I found this formula in D18...: =($D$18/12)*C18). A circular reference is when a cell refers to itself, either directly or, more often, through a loop of formulas in different cells.
These circular references are possible in Excel for iterative calculations.
Two scenarios:
either this circular reference is an error: to be corrected.
or it is intentional (the case of iterative calculation) and in that case, you need to go to Excel options under the formula submenu and check the box "enable iterative calculation." You have the option to define the number of iterations and/or the precision of the calculation to be performed ("maximum deviation").
In your workbook, allowing for this iterative calculation obviously gives a result at the level of the desired formulas, but it is up to you to analyze your tables to determine whether these references are errors or not.
To perform this analysis, Excel offers auditing tools.
--
If you need anything, just ask me.
Re,
As our friend dobo69 says, where is it happening!
Apparently this file does not have any issues; I think in Excel 2007 it is located in the same place as in version 2003, check if in tools/options the Automatic Calculation tab is checked
A+
Mike-31
A problem without a solution is a poorly posed problem (Einstein)
As our friend dobo69 says, where is it happening!
Apparently this file does not have any issues; I think in Excel 2007 it is located in the same place as in version 2003, check if in tools/options the Automatic Calculation tab is checked
A+
Mike-31
A problem without a solution is a poorly posed problem (Einstein)
Hello,
I'm sorry, I forgot to specify the exact location,
it's in the marketing tab,
I'm trying to sum() the different totals and the result is 0
Actually, it doesn't work when it comes to summing up the results.
I'm sorry, I forgot to specify the exact location,
it's in the marketing tab,
I'm trying to sum() the different totals and the result is 0
Actually, it doesn't work when it comes to summing up the results.
