If the formula doesn’t drag as expected, make sure the cells you are dragging from and to do not contain any data that could interfere with the formula. Also, ensure that the cells you are dragging to have the correct format and are in the intended direction.