Count Number of occurences of several texts in a range of cells

K

kbeirne

I’m trying to use a COUNTIFS fx to count only certain answers from a list of
answers. Answers can only be chosen from a predetermined drop down list.

Answers I want to count are “S&Dâ€, “TOâ€, “Both†and “Yâ€

Range is the same for all cells. Other answers are an option but I do not
want to count them.

I’ve tried these but they won’t seem to work:
=countifs(o2:eek:93, “S&Dâ€, o2:eek:93, “TOâ€, o2:eek:93, “Bothâ€, o2:eek:93, “Yâ€)
=countifs(o2:eek:93, “S&Dâ€, “TOâ€, “Bothâ€, “Yâ€)

Any ideas?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Count multiple cells against multiple criteria in an Excel spreads 7
How do I count cells with specific value? 5
count number of dates in a row of cel before or after a variable d 5
How to use a variable as an argument in .FliiDown 4
Identifying correct elements with Countif 3
SUMPRODUCT - Count Various criteria in same column (exclude other) 8
Formula for totaling occurrences in a specified range 1
Using Survey Monkey 3

Top