Forum Discussion

TChern745's avatar
TChern745
Copper Contributor
Jun 13, 2024

Inserting Rows Outside of Sum Range Changes the Rows Summed

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!!

excel
Formulas and Functions
  • dscheikey's avatar
    dscheikey
    Bronze Contributor
    Jun 15, 2024

    TChern745 

    Hi, what you are describing here is relatively implausible.

    Are you actually adding a whole row or are you inserting cells?

    How do the formulas in column C differ from those in D-R?


    Can you post the formulas here?

     

Resources