Skip to content
Procedure

Totalling the rows or columns of a data table

Statistics • Data Interpretation • Table

Statement

In a table whose rows and columns are two classifications of the same quantity, the total for one category of either classification is the sum of the entries along its row or column; comparisons between categories, differences between them and percentage changes are then made on those totals, or on sums of selected entries where the question names them.

How to use it

  1. 1Decide first whether the question is about rows or about columns, and total only those the options name.
  2. 2Add the totals the other way as a check: the sum of the row totals must equal the sum of the column totals.
  3. 3For a difference between two totals, subtract entry by entry and add the differences; it avoids two long sums.
  4. 4When the options are close, compute each total exactly; a single slip reverses the order.

Worked example

A shop's sales (in units) are: Pens and Pencils in the months Jan, Feb, Mar. Which month had the larger total sales, Jan or Mar, and by how much?

Step-by-step

  1. 1
    Jan: ; Mar:

    Why: A month's total is the sum of its column across both products.

  2. 2
  3. 3
    Check entry by entry:

    Why: The difference of totals equals the sum of the entry differences.

Answer

March, by units

Watch out

Totalling the wrong direction — rows when the question asks about columns — gives a plausible-looking answer to a different question. A percentage change between totals is taken on the earlier or named base total, not on the sum of the percentage changes of the entries.

Also known as

row total, column total, table totals, data table sum, total production over the years, compare totals in a table, tabular data interpretation, sum a row of a table

Appears in past papers

2026 (II)

2025 (I)

2022 (I)