#REF! error when inserting row into table

Hi,

Unfortunately, when you simply insert a new Row in a Table (or a Range) the formulas are are not automatically copied'.

I have attached a "revised" version of your Gold (Inventory) sheet that includes the following:-

The Total row that you had has been deleted
A new Total Row has been added from Table Tools - Design - Total Row has been "ticked"
IFERROR has been added to the formulas so you will not get #REF! error or #DIV/0! error if the related cells are blank.

If you select the "marker" on the bottom right cell (M27 in the attached - do not select the cell) the "cross" changes to an "arrow" and if you drag it down more rows appear with the formulas copied automatically.
Please note the total Row automatically "moves down" to the last row.
If you select any cell in the new Total Row, click the down arrow, and you will have numerous options - Count - Average - Sum etc. etc.

Now you do not have to insert rows - hopefully problem solved.

Please let me know if this works for you.

Regards

peterrc