I have a table with music bands. Each band has a genre that is shown in a single select field:
I want to add a new field with a formula that counts the number of times each genre appears in the table. In the screenshot above, this would be 2 for Rock and Soul and 1 for Country. However, the count function only returns the number of items in an array which is always 1 in my case (because a band has 1 genre).
Is this possible with a formula? I am actually looking for the equivalent of the COUNTIF function in a spreadsheet.