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

[USAMax]

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]

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