Your task
Using inventory-counts.csv columns A:F, calculate expected closing and counted difference. Write the metric definition and output unit before choosing a formula.
Hint
Use a separate calculation area so the raw source stays unchanged. Keep excluded rows and reconcile the total.
Worked solution
In G2 enter =B2+C2-D2-E2; in H2 enter =F2-G2; fill through row 7. P02 expected 15, counted 14, difference -1; every other SKU difference 0.
Boundary check
Sum H2:H7 = -1, but also count nonzero rows; positive and negative errors can otherwise cancel out.
Make the reasoning yours.
Try the activity before reading its reference. Keep your sources, commands and assumptions with your work. Companion activities are unsaved self-practice and do not award a certificate or change lesson progress.