Summing

[Guest]

I summed a column. When I highlight the cell where the total is supposed to
go, the answer is there. When I don't, it's not. What did I do wrong?

 

[Guest]

It could be that the cell has been formatted as white text.
Check that your font colour for the cell is set at Automatic.
BCB

 

[Guest]

I checked that already, but it wasn't. Any other ideas?

 

[Ragdyer]

Did you check "Conditional Formatting"?

 

[Guest]

There is a conditional format for those cells, but it only applies if the
value isn't a number.