Gathering total number of Yes/no responses into one column out of a certain number

Miguel P

I have a multiple drop down cells from a "form" i set up that either have Yes or No as responses.
What Im trying to do is to have a cell at the end that provides a number of how many yes there are and give me that total number.

AKnight

Hi @Miguel P !

I would create a new column at the end of your sheet that is a text/number. You can name it whatever you want, I suggest "Total 'Yes'". Then in the first cell add this formula:

=COUNTIF([First Column]@row:[Last Column]@row, "Yes")

The first column being the first column with a yes/no response, and the last column being the last column with a yes/no response. By tagging the first and last column with row, you will create a range of including all the columns between them.

You can then convert it to a column formula by right clicking the cell so it applies to the whole column and calculates any new responses.

EDIT: I just saw this question is tagged as a multi-select dropdown. I would add a HAS function at the end to accommodate for that like so:

=COUNTIF([First Column]@row:[Last Column]@row, HAS(@cell, "Yes"))