Re; Function Issues

I have this function: =SUM(C9:BP9). It is supposed to calculate all the
values within the said row and render a total. However, what it does is give
a total that is 2 off from the total. Example a manual Summing will give me
108995, using =SUM(C9:BP9). I'll get 108993 or I'll do another manual
summing to give me 1959847, using =SUM(C10:BP10) I'll get 1959845. I am also
running Office 97, so there may be SP issues or missing SP updates to get
this stuff to work correctly.

Any ideas?

Thanks

You probably have some text values in this range which SUM will ignore,
press F5 and special, select constants amd umcheck everything but text to
see if some cells are selected (if they derive from formulas select formulas
and text)
Or else you have a lot of decimal values not shown through formatting


Regards,

Peo Sjoblom

"Jay" wrote:

> I have this function: =SUM(C9:BP9). It is supposed to calculate all the
> values within the said row and render a total. However, what it does is give
> a total that is 2 off from the total. Example a manual Summing will give me
> 108995, using =SUM(C9:BP9). I'll get 108993 or I'll do another manual
> summing to give me 1959847, using =SUM(C10:BP10) I'll get 1959845. I am also
> running Office 97, so there may be SP issues or missing SP updates to get
> this stuff to work correctly.
>
> Any ideas?
>
> Thanks

It sounds like you are summing values that were derived from formulae as opposed to summing values that were actually typed in. Summing derived values causes a rounding issue in that the derived value is likely not exactly what is showing in the cell. You may have 99.87 showing in the cell but the actual derived value may be 99.86957624 and when several derived values are summed the result can be thrown off because it includes all the decimal places that aren't showing in each of the cells.

You can check the actual value that the formula is deriving by highlighting everything in the formula bar and hitting the F9 key. But remember to hit the Esc key before leaving the formula bar.

The way around it is to place your formulae within the ROUND() function (or one of the related functions) for each of the derived values and then do your summing.