I am using a couple columns that are summed up in a cell at the bottom of a worksheet, but the rows in each column are dynamic. This is NOT a table and rows are added and deleted from the base file we use as a template every time. When rows are deleted, the calculations are all still good, obviously. When rows are added (either by copying existing rows and inserting the copied row, or by just inserting a new row) the sum formula doesn't update to include the new rows. I'm sure this is relatively simple, but I can't figure out how to fix this. Thanks in advance for any help!