Excel Subtotal Audit

Use this workflow after generating or modifying an Excel report to catch silent spreadsheet defects that simple file-exists or sheet-exists checks will miss.

The core idea is:

1. Read back the finished workbook.
2. Print every populated output row, including formulas.
3. Identify section subtotal rows.
4. Independently verify that each subtotal formula includes all visible detail rows intended for that section.
5. Treat any mismatch as a report defect, even if the workbook opens successfully and looks formatted correctly.

This is especially useful for generated financial statements, operational summaries, rollups, grouped exports, and any worksheet where formulas summarize nearby detail rows.

When to use

Use this skill when: