Hi All,

I am having an issue where I need to add rows to an existing sheet above a few rows with sum calculations. The added rows are not within the sum range. When I do this, some of the sum formulas don’t adjust the sum range for the added rows. The error only presents itself in some of the columns (i.e. the sum formula in column C updates but the sum formula in columns D through R with the exact same row range and sum function as column C don’t update). I rebuilt the entire file trying to get rid of this issue, but it has persisted in the new XLS. What am I doing wrong? Is this a settings thing? Please help!!

​Hi All, I am having an issue where I need to add rows to an existing sheet above a few rows with sum calculations. The added rows are not within the sum range. When I do this, some of the sum formulas don’t adjust the sum range for the added rows. The error only presents itself in some of the columns (i.e. the sum formula in column C updates but the sum formula in columns D through R with the exact same row range and sum function as column C don’t update). I rebuilt the entire file trying to get rid of this issue, but it has persisted in the new XLS. What am I doing wrong? Is this a settings thing? Please help!!  Read More

​