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:blush:93, “S&Dâ€, o2:blush:93, “TOâ€, o2:blush:93, “Bothâ€, o2:blush:93, “Yâ€)
=countifs(o2:blush: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 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
Automatically generating a number range 2
Combine query to count products with similar names 8
How to populate a column in a row based on a value in another colu 3
Match several values in ‘Summary Sheet’ to several values in ‘Mast 4
count number of specific entries but over multiple fields! 9

Top