What do you get using =G10+G16+G37+G52+G127+G156+G178
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email
"Dave F" wrote in message
...
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?
--
Brevity is the soul of wit.