Mar 13 2021 03:29 PM
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
Mar 13 2021 10:39 PM
SolutionThat'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]]
Mar 14 2021 07:12 AM
Mar 14 2021 02:01 PM
You're welcome @George_Weston! Glad it worked as desired.
Mar 14 2021 02:27 PM
Mar 14 2021 09:37 PM
Mar 13 2021 10:39 PM
SolutionThat'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]]