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
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.