"VALUE"

[flkulchar]

My spreadsheet appears as follows:


A B C D
1
"VALUE"
2 2 5 6 13

My D column asks for the sum of A+B+C...

WHY DOES THE CELL RETURN A DISPLAY OF "VALUE" WHEN THE
CELLS THAT ARE ADDED ARE BLANK??

Thanks,

Larry

 

[Patti]

Check your formula to make sure it includes the rows --
=A1+B1+B1

Also make sure there is no data in the row by using the
delete key -- using the space bar to clear the cells can
cause that error.

 

[Patti]

Oops! Typo! I meant =A1+B1+C1

-----Original Message-----
Check your formula to make sure it includes the rows --
=A1+B1+B1

Also make sure there is no data in the row by using the
delete key -- using the space bar to clear the cells can
cause that error.

.

 

[Jack Schitt]

B1 and C1 may APPEAR blank but in fact they contain text strings that have
no visible appearance. Perhaps they contain formulae that return "".
Try using
=SUM(A1:C1)
or
=A1+N(B1)+N(C1)