PRACTICAL RESOURCES / FREE
A weekly order tracker with totals you can trace
A small shop has an Excel order tracker. Two formulas omit the last order, and a completion rate divides the wrong values. This demonstration shows the logic of three repairs without changing the recorded orders.
Fictional demonstration — not customer work or measured results.
View the supplied fictional records
| Row | Item | Units | Unit price | Expected line total |
|---|---|---|---|---|
| 2 | Notebooks | 10 | $6.00 | $60.00 |
| 3 | Desk pads | 4 | $15.00 | $60.00 |
| 4 | Pens | 20 | $3.00 | $60.00 |
| 5 | Folders | 30 | $2.00 | $60.00 |
Before: three answers from the wrong cells
Columns A:D are Item, Units, Unit price and Line total. Four orders occupy rows 2–5. E2 is completed orders (3); F2 is total orders (5).
| Cell | Purpose | Current formula | Displayed result |
|---|---|---|---|
| D5 | Fourth order total | =B5*C4 | $90.00 |
| D6 | All order revenue | =SUM(D2:D4) | $180.00 |
| G2 | Completion rate | =F2/E2 | 166.7% |
After: each formula matches its stated purpose
| Cell | Repaired formula | Expected result | Check |
|---|---|---|---|
| D5 | =B5*C5 | $60.00 | 30 × $2.00 = $60.00 |
| D6 | =SUM(D2:D5) | $240.00 | Four $60.00 lines sum to $240.00 |
| G2 | =E2/F2 | 60.0% | 3 completed orders ÷ 5 total orders = 0.6 |
What changed
- Use the unit price from the same row as the quantity.
- Include every order row in the total.
- Put completed orders in the numerator; format the result as a percentage.
How we check the work
- Verify each of the four line totals independently.
- Compare the final sum with a hand calculation.
- Test completion counts 0 and 5 against total 5; agree how a zero total should display before adding a guard.
This illustration demonstrates formula logic. It is not a downloadable repaired customer workbook. The purchased service uses your original .xlsx and expected calculations.
Repair up to eight formula errors in one workbook with up to five sheets — $59 one time.
See scope and pricing