How do subtotals help me understand a larger table?

A subtotal is a combined count or value for a selected group of rows. It lets you see the group’s size without adding each component every time. The rows that feed into it are its component rows; the subtotal is their combined amount. A grand total, by contrast, is for the whole set covered by the table.

Here’s a small count example. Assume these figures represent attendance at a club event, split by day and session:

Day and session       People
Monday morning           12
Monday afternoon          8
Monday subtotal          20
Tuesday morning          10
Tuesday afternoon         9
Tuesday subtotal         19
Grand total              39

The Monday subtotal combines Monday’s two session rows: 12 + 8 = 20. The grand total combines the two day subtotals: 20 + 19 = 39. Component counts can be combined to answer a broader question, while a total represents the observations in the full set. [S1]

Look for clues such as labels like “subtotal” or “total,” indentation, spacing, or a heading that names a group. Then check what the subtotal includes: in the example, “Monday subtotal” covers only Monday morning and Monday afternoon, not Tuesday’s entries.

If the layout doesn’t make the grouping clear, don’t assume. Write down the rows you think are included and check that the subtotal matches their sum. For Monday, that check is 12 + 8 = 20. If it does not match, there may be a row you missed, an entry you misread, or a different definition of the group. The numbers alone cannot tell you which explanation is correct; look for a label or ask whoever prepared the table.

No. Adding every displayed number would count each session twice: once in its component row and again in the subtotal that already includes it. For the example, adding 12 + 8 + 20 + 10 + 9 + 19 would give 78, but that is not the attendance. The Monday entries are already included in 20, and the Tuesday entries are already included in 19.

Instead, choose one consistent level. Add the component rows only: 12 + 8 + 10 + 9 = 39. Or add the day subtotals only: 20 + 19 = 39. Both methods give the same grand total because they cover the same people once. This is the key double-counting check: never combine a subtotal with the component rows already included in that subtotal.

Choose rows that match the question, and make sure the selected rows don’t overlap. For Monday only, use its subtotal (20) or its two session entries (12 + 8), but not both. For afternoon attendance across both days, use the afternoon component rows: 8 + 9 = 17. Don’t add either day subtotal to that calculation, because each subtotal also includes a morning entry.

A useful way to annotate a table is to mark each selected row as either a component or a subtotal, then ask: “Does this selected value already contain any other selected value?” If yes, remove one of the overlapping choices. A frequency-table example likewise combines component counts for a broader range and treats the frequency total as the number of observations in the sample. [S1] That example supports the counting distinction; it does not specifically define spreadsheet subtotals.