#VALUE! ?

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
 
F

Frank Kabel

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
 
D

Dave Peterson

I think you'll find that =sum() will ignore text in the range. But it does have
trouble with errors (like #value!).
 
Top