#VALUE! ?

  • Thread starter Thread starter Steven
  • Start date Start date
S

Steven

for some reason some of my cells now show #VALUE! in them, i have not
changed anything. all i have done is use the file on one pc, copy to floppy
and use on another pc, any ideas how to fix this?

the cells in question have forumlas like;

C72=SUM(C3:C71)
C89=C72

Many thanks,
Steve
 
Hi
and there aren't any errors in the range you sum?
If you like email me your file:
frank[dot]kabel[at]freenet[dot]de
 
Most likely that a cell or cells in the C73:C71 range contains text. Make
sure all the values in these cells are numbers only.
 
I think you'll find that =sum() will ignore text in the range. But it does have
trouble with errors (like #value!).
 
Back
Top