Inserted row above total is not included in total. Any solution would be welcomed!

USAMax

Well-known Member
Joined
May 31, 2006
Messages
821
I have a worksheet with a list of properties. Every time an expense is added to the list it goes on the last row for the property, just above the total.

I welcome any kind of solution either a worksheet formula or a VBA solution that would insert the new row and update the =SUBTOTAL( and =Sum(.

Thanks everyone!
 

arthurbr

Well-known Member
Joined
Dec 8, 2006
Messages
1,898
Select the expense range - Insert - Table and rebuild your sum formula (sthg like =SUM([Column1]) if no headers). Then when inserting, the total will update automatically
 

Forum statistics

Threads
1,078,393
Messages
5,339,931
Members
399,340
Latest member
JasonT903

Some videos you may like

This Week's Hot Topics

Top