Forum Discussion

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 for...

excel

Formulas and Functions

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?