Spot the Range That Stopped Growing
Identify a fixed-range formula that omits newly inserted spreadsheet rows.
The new enterprise row was added below the old total boundary. Find the likely source of the $300,000 understatement. The newly added row below the old formula boundary Correct. A row added below a fixed range is a classic silent omission: no error code, just an incomplete total. The summary total cell at the top of the report The total is where the symptom appears, but the defect is usually in the precedent boundary feeding it. The colored formatting on the header row Formatting can distract reviewers, but color is not the calculation dependency. Audit the references. The coffee mug…
Sign up free — one personalized lesson every day, matched to your role and goals.
Already have an account? Sign in