I am brand new to excel (and learning quickly). I am trying to get some specific results from a google poll, but I'm hitting a snag. I'm looking for a formula that will add the total number of results that have two answers of text.
Example:
Column A Column B
Never Yes
1-2 times No
Never No
3-5 times Yes
Never Yes
I would like to get the total of all the rows that have "never" in column A AND a "Yes" in column B. So this example would be 2 people that answered this way.
Thank you!!
Bookmarks