Compiling Survey Results

Hello All,

There's a survey we ask people to fill out so we can better provide services. There are 32 specific locations and a long list of questions. I'd like to compile all of this information into a metrics sheet, and in the end create a dashboard.

By some miracle was able to tally how many times the specific location was selected.

=COUNTIF({Parent Education Survey Classroom}, Center2)

I'd like to be able to break it down even more by location and weather or not the option was checked. I don't know how to write the next expression needed.

I've attached a couple images.

Thank you in advance for any information provided.

survey sheet.JPG

Find more posts tagged with

Non-profit

Formulas

Support

Cell linking

Comments

Andrée Starå

Hi,

Try this.

=COUNTIFS({Parent Education Survey Classroom}; Center2; {Adult Education Checkbox Range}; 1)

The same version but with the below changes for your and others convenience.

=COUNTIFS({Parent Education Survey Classroom}, Center2, {Adult Education Checkbox Range}, 1)

Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.

Did it work?

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Kidco Head Start

Hi @andreestara

Thank you for the response! I tried using

=COUNTIFS({Parent Education Survey Classroom}, Center2, {Adult Education Checkbox Range}, 1)

however I get an #INVALID REF error.

Sign in to join the conversation!

Quick Links

Trending discussions

Lookup Value Issues
I am trying to populate a column from Sheet A into Sheet B and Sheet C. My Lookup column for Sheet A is formatted as such so there is a ' in front to account for ones that have a leading 0 and some do not. Each ID should be 6 digits long. I made a helper column looking at this Dealer ID column to try and get rid of that…
Separating Data into Multiple Rows
am I able to separate this into multiple rows? in a new sheet? Desired Result -
Index Distinct Support
I would like to parse out this data by creating a listing with a row for each person, for each project they appear on, for each month. I think this would only give me the groupings anyways, but this doesnt seem to even get me started - it popped up then people have disappeared.