I’m making a spreadsheet in CALC.
Lets say one column is countries. How would i use a function to show how many times x y z has been entered in the column?
The answer depends a bit on the complexity, but in general there a two approaches.
- Single Country “x” count is of interest (or a low, limited number of never changing countries)
Use formula =COUNTIF(A:A,"=x") (assumimg countries appear in column “A”)
- Overview of all existing countries and their respective count is required, as in the follwing screenshot
Create a pivot table using Data -> Pivot Table -> Create ... according to the following sample layout:
