A table has one row per county per year, covering 47 counties from 2020 to 2024.
The first few rows, using Kenya's counties:
| A | B | C |
|---|
| 1 | county | year | children_immunized |
| 2 | Baringo | 2020 | 18,240 |
| 3 | Baringo | 2021 | 18,910 |
| 4 | Baringo | 2022 | 19,305 |
| 5 | Baringo | 2023 | 19,880 |
| 6 | Baringo | 2024 | 20,115 |
| 7 | Bomet | 2020 | 21,030 |
| 8 | Bomet | 2021 | 21,460 |
| ⋮ | ⋮ | ⋮ | ⋮ |
How many rows does the table have?
47 counties × 5 years = 235 rows. Each county appears once for every year, so the row count is the number of counties times the number of years.
47 is the number of counties, but each county appears once per year. How many times does each county show up? Try again.
5 is the number of years, but each year has a row for every county. Try again.
You added counties and years. But every county has a row for every year, so the two numbers multiply. Try again.
Close: 47 × 4. But 2020 to 2024 includes both ends: 2020, 2021, 2022, 2023, 2024 is five years. Try again.
Nearly: 236 is the number of the last spreadsheet row, but row 1 holds the column names, not data. How many rows of data are there? Try again.
Think about how many times each county appears. It gets one row for each year from 2020 to 2024. Try again.