Re; Function Issues

[Jay]

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

 

[Peo Sjoblom]

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