Jo,

It sounds to me as if you might be as well converting your Invoice range to an Excel table that will expand as you add data whilst keeping a SUMIF type total row at the bottom.
Here is one of many video tutorials that you will find...

https://www.youtube.com/watch?v=VMScRbwDSXE

Hope that helps.