How do you clear the cells.

I'm guessing you hit the spacebar. That doesn't clear the cell--it puts in a
space character. (It may look the same, but it's not.)

Try clearing the cells by hitting the delete key on the keyboard.
(or edit|clear|contents)

Juco wrote:

when i clear all the cells in the formula below I get #VALUE! showing in
the cell (M15)
Is there a way to just show a blank cell? and not have this message
showing.

thanks

=M7+M8+M13+M14

--

Dave Peterson