Hi, I have an excel doc that has a more involved SUM formula at the bottom of a column. =SUM(Q55*I55)+(Q56*I56)+......
When I insert rows, this SUM formula obviously does not update to account for the new rows. Sometimes, my colleagues will add up to 20 new rows of data without realizing they aren't getting summed at the bottom. Is there an easy way to ensure they are included in the SUM formula. I've had to manually go through and type in the missing parts of the equation and at times that's too much to do.
I've looked into the Offset option, but I'm not sure it would work here since we have an equation in the formula and not just a range.
Can anyone advise?
Thanks!