thanks! that does work. though my team didn't have this issue last week. it is only after we added new rows to the file that this problem started occuring. we simply inserted rows and dragged the formulas down. was hoping to get things back to what they were but this is certainly a good work around.