In Sheets, with provinces in B2:B13 and the category list in H2:H5, type the COUNTIF for row 2 that fills down correctly.
In Sheets, with provinces in B2:B13 and the category list in H2:H5, type the COUNTIF for row 2 that fills down correctly.
Answer
=COUNTIF(B2:B13, H2)
Absolute range (every copy scans the same twelve cells), relative criterion (each copy asks about its own row). Filled down: 2, 3, 4, 3.