Normally when i drag a formula by clicking the mouse and dragging the formula
to fill other cells the cell reference changes as intended - for some reason
when I drag the formula to the right the cells reference does not change - it
is staying the same - I am not using the $