How do you find the total numbers of times a word has been used?

Posted on

QUESTION :

For example, say I’m trying to total yes/no questions. I want to be able to go down a column and see how many times the answer was yes and how many times the answer was no. I’m also using a drop-down selection to try to make things easier. I’ve tried using the sumif formula, but I am having trouble assigning value to the text.

ANSWER :

Use:

=COUNTIF(A:A,"yes")
=COUNTIF(A:A,"no")

enter image description here

Leave a Reply

Your email address will not be published. Required fields are marked *