Forum Discussion
Solved
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 ...
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.
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!