Forum Discussion
Table count based on a list
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?
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.
2 Replies
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!
