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

USAMax

Well-known Member
Joined
May 31, 2006
Messages
826
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!
 

Some videos you may like

Excel Facts

Excel Can Read to You
Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.

arthurbr

Well-known Member
Joined
Dec 8, 2006
Messages
2,035
Office Version
2010
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
 

Watch MrExcel Video

Forum statistics

Threads
1,102,554
Messages
5,487,530
Members
407,604
Latest member
sama9000

This Week's Hot Topics

Top