"VALUE"

F

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
 
P

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.
 
P

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.

.
Click to expand...
 
J

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)
 
Top