Fix Measurement Totals Formulas

My RA-Billing workbook for construction measurement is returning the wrong totals on the dashboard. The layout, data feeds, and references are all in place; the problem sits squarely in the formulas that roll individual sheet quantities up to the summary view.

Here is what you will be working with: an XLSX file that tracks item-wise measurements, applies billing percentages, and then displays cumulative quantities and values on a slicer-driven dashboard. Somewhere in the chain the measurement totals inflate, so the final numbers shown in the dashboard do not match the detailed sheets.

Your task is to trace the miscalculations, correct or rewrite the offending formulas, and confirm that the dashboard totals now match the underlying measurement logs. I expect the fix to hold even after fresh data is pasted into the source sheets.

Deliverable: a clean, working version of the workbook with comments (or cell notes) on every formula you adjust, so I can follow your logic for future edits.

If you regularly debug SUMIFS, INDEX/MATCH, dynamic arrays, or similar functions in construction cost models, this should be quick work. Let me know your estimated turnaround and any clarifications you need.