If you use Google Sheets to collect responses from Google Form submissions, you may end up with a lot of columns of short word answers. Wouldn't it be great if you could just have a numerical value for how many people gave a certain response? Well, you can
Using the COUNTIF formula, you can count the number of responses with a certain text value in a range. For example, if you want to count all the times "Yes" appears in column C, you would use the formula: =COUNTIF(C:C, "Yes").
The little comment box that appears above the cell indicates the value that will be returned by the formula. There you have it, quickly add up the number of text responses from a Google Form!
WARNING - double check your formulas, a wrong comma or missing "" can leave you with errors.
I'm passionate about Music, Music Technology, EdTech and Education. I started off my career as a musician and sound engineer then quickly progressed into teaching.