Removing the $ after the column letter and then filling down worked perfectly.