SOLVED

Table count based on a list

Copper Contributor

HI, 

 

I have a number of people who've responded to a survey, saying the region in which they live, and then the key townships they visit. 


I want to display that data in a way that shows what towns people visit. 


I have responses by column, and I want to run a countif ( i think)  on the table, showing how often the townships occur. I can't seem to figure out a way without doing it manually? 

 

 

2 Replies
best response confirmed by bhopenz (Copper Contributor)
Solution

@bhopenz Perhaps a simple COUNTIF is enough. Have converted the table with the answers to a structured table, by the way. Then you can reference the entire table by its name and count the occurrences for each of the listed townships.

See attached.

many thanks, i think i over complicated my table selection title!
1 best response

Accepted Solutions
best response confirmed by bhopenz (Copper Contributor)
Solution

@bhopenz Perhaps a simple COUNTIF is enough. Have converted the table with the answers to a structured table, by the way. Then you can reference the entire table by its name and count the occurrences for each of the listed townships.

See attached.

View solution in original post