If you drag it down to the cells you want it should copy and change the cells to their new relative cells. You will need to manually change the absolute cell to the new one it would be, or it would still be trying to use $B$4

No Problem