SOLVED

Table count based on a list

%3CLINGO-SUB%20id%3D%22lingo-sub-2309213%22%20slang%3D%22en-US%22%3ETable%20count%20based%20on%20a%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2309213%22%20slang%3D%22en-US%22%3E%3CP%3EHI%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20number%20of%20people%20who've%20responded%20to%20a%20survey%2C%20saying%20the%20region%20in%20which%20they%20live%2C%20and%20then%20the%20key%20townships%20they%20visit.%26nbsp%3B%3C%2FP%3E%3CP%3E%3CBR%20%2F%3EI%20want%20to%20display%20that%20data%20in%20a%20way%20that%20shows%20what%20towns%20people%20visit.%26nbsp%3B%3C%2FP%3E%3CP%3E%3CBR%20%2F%3EI%20have%20responses%20by%20column%2C%20and%20I%20want%20to%20run%20a%20countif%20(%20i%20think)%26nbsp%3B%20on%20the%20table%2C%20showing%20how%20often%20the%20townships%20occur.%20I%20can't%20seem%20to%20figure%20out%20a%20way%20without%20doing%20it%20manually%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2309213%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2309277%22%20slang%3D%22en-US%22%3ERe%3A%20Table%20count%20based%20on%20a%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2309277%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1041409%22%20target%3D%22_blank%22%3E%40bhopenz%3C%2FA%3E%26nbsp%3BPerhaps%20a%20simple%20COUNTIF%20is%20enough.%20Have%20converted%20the%20table%20with%20the%20answers%20to%20a%20structured%20table%2C%20by%20the%20way.%20Then%20you%20can%20reference%20the%20entire%20table%20by%20its%20name%20and%20count%20the%20occurrences%20for%20each%20of%20the%20listed%20townships.%3C%2FP%3E%3CP%3ESee%20attached.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2319100%22%20slang%3D%22en-US%22%3ERe%3A%20Table%20count%20based%20on%20a%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2319100%22%20slang%3D%22en-US%22%3Emany%20thanks%2C%20i%20think%20i%20over%20complicated%20my%20table%20selection%20title!%3C%2FLINGO-BODY%3E
New 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 (New 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!