G
Guest
This is a new one.
Using the SUM function in XL 2003 to sum up a series of cells:
=SUM(G10+G16+G37+G52+G127+G156+G178)
All of these cells have values in them, which are themselves sums of other
ranges. All cells in this formula are themselves calculating correctly,
however, this formula is resolving to 0 (all calculations in the cells above
are positive, so 0 is mathematically impossible.)
Calculation is set to automatic, there are no links to external web sites
and the cells referenced above, are formatted as currency.
Thoughts?
Using the SUM function in XL 2003 to sum up a series of cells:
=SUM(G10+G16+G37+G52+G127+G156+G178)
All of these cells have values in them, which are themselves sums of other
ranges. All cells in this formula are themselves calculating correctly,
however, this formula is resolving to 0 (all calculations in the cells above
are positive, so 0 is mathematically impossible.)
Calculation is set to automatic, there are no links to external web sites
and the cells referenced above, are formatted as currency.
Thoughts?