| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Cannot change a formula
I am using a worksheet that counts the number of days employees have worked. The worksheet was written by someone else who have 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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help: Can I change the date formula from mm/dd/yyyy to "mmm-yy" et | Excel Discussion (Misc queries) | |||
| Simple formula doesn't quite add up | Excel Discussion (Misc queries) | |||
| how do I make a formula NOT change when the data range is moved? | Excel Discussion (Misc queries) | |||
| Change Row Numbers in Formula with Macro | Excel Discussion (Misc queries) | |||
| Can I use TODAY Function in a formula that will not change it the. | Excel Discussion (Misc queries) | |||
Threaded Mode
