One possibility is that the source numbers you are trying to sum are actually
text numbers, not real numbers.

Copy an empty cell, then select the source "numbers" and do a paste special
add ok. This should convert the text numbers to real numbers and SUM will
now work.

You should also ensure that the calc mode is set to Automatic. To
check/change calc mode, click Tools Options Calculation tab (Options are
there). Ensure Automatic is checked OK.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Ravi" wrote:
1) I have referenced values from One work sheet to another.When I try to sum
up the referenced values I get 'zero'. Even when I try to do a calculation
with referenced value it does not work.
2) Again if in a work book I insert a formula a particular cell the result
again shows 'zero'. While the formula works in other cells.

Why am i facing these problem. My office version is licensed one. It office
2000 installed on Windows XP.

Can anybody plese help me to resolve this.

With regards
Ravi