Example 10: Missing cells using row and column totals
Last Updated On: Fri Aug 28 2026| Region | Q1 | Q2 | Total |
|---|---|---|---|
| North | 40 | ? | 100 |
| South | ? | 50 | 90 |
| All regions | 80 | ? | 190 |
A "?" marks a missing value.
Question
Find the three missing values.
Solution
- North Q2 = 100 - 40 = 60 (row total).
- South Q1 = 90 - 50 = 40 (row total).
- All-regions Q2 = 60 + 50 = 110 (column sum).
- Check: 80 + 110 = 190 and 40 + 40 = 80.
PreviousShowing 11 / 11