Help with a formula

[Richard F]

I am using a worksheet that counts the number of days
employees have worked. The worksheet was written by someone else who
has left. I need to change the number of some rows in this formula.


=COUNTIF(D$14$160,$V32)+COUNTIF(D$175$225,$V31)+M250+M238

M250 and M238 are the results of another countif formula. When I try
and change the number of the rows to M251 and M 239 the formula no
longer returns a value and I see the formula in the cell on the
worksheet. Also the different values of the rows and columns become
colored. How can I change the formula so it returns the value its
supposed to?

Richard

 

[Dave Peterson]

It sounds like the cell with the formula became text (sometimes excel likes to
help and it doesn't guess correctly).

Format that formula cell as General (or some number format)
format|cells|number tab
and then (with that cell still selected), hit f2, then enter.