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.

Richard F wrote:


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:D$160,$V32)+COUNTIF(D$175:D$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