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

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