PDA

View Full Version : Auto Updating Row for Sum Grand Total



DrViagrin
04-19-2018, 11:06 AM
I am trying to create an excel row, where every time I add new information it bumps the grand total down another row. I guess you could call it an auto update grand total row. Is that possible?

Paul_Hossler
04-19-2018, 12:05 PM
The most reliable why I've ever found is using OFFSET()

As long as I insert the new row(s) above the SUM() line, it seems to work

22065


Excel will adjust row addresses, but I've never found a reliable way to insert a row at the end of the data without OFFSET