Totals in Table Get Errors When Inserting, Deleting or Sorting Rows

[George_Weston]

Hi

I have a maintenance log and it has columns for parts cost, labor cost, total cost and cumulative cost.

It appears that the total cost column formula gets confused when I insert a row somewhere in the table or delete a row and the cell row references change.  Sorting also seems to sometimes generate these errors.  

I have attached the worksheet file and hope someone can help me with the total cost formula/function.

Thanks!

George

[#2 · Accepted solution]

@George_Weston 

That's because you are not using structural reference in the formula in Total Cost Table Column.

Replace the existing formula in L14 with the following one and then copy it down.

=[@[Cost of Parts]]+[@[Cost of Labor]]

[#3]

Thank you. Works well.

[#4]

You're welcome @George_Weston! Glad it worked as desired.

[#5]

I need to learn about structural references. I was aware of them but not really familiar with using them. So, thanks again. I'll be doing some learning.
Regards,
George

[#6]

Happy learning!
All the best!