Calculating Cells

[mpfree]

Doing a draw sheet. I have a static number in column E. I want tha
same number to appear in column M on the same row and as I ente
numbers into the columns on that same row, those numbers subtract fro
the total in column M so column M dynamically shows the difference.
was using the following functions in column M(bear in mind, I'm
novice):

=sum(E10)-(F10)-(G10)-(H10)-(I10)-(J10)-(K10)-(L10)

Everything was working fine until I got to row 60. I put the sam
function in M60 and I get #VALUE. Perhaps someone can give me
different function which would work better. I suck at math

 

[Frank Kabel]

Hi
in M10 put
=E10-SUM(F10:L10)
and copy down

the #VALUE error can occur in your original formula if you have a text
value in one of these cells

 

[mpfree]

Thank you very much Frank. Certainly that function is less involve
than the one I came up with. Also, I found out about values in cell
messing up the function. Apparently there was a hidden text value i
one of the cells. I just went down the row and hit delete in all th
cells and VOILA! All fixed