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

  • Thread starter Thread starter kbeirne
  • Start date Start date
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:o93, “S&Dâ€, o2:o93, “TOâ€, o2:o93, “Bothâ€, o2:o93, “Yâ€)
=countifs(o2:o93, “S&Dâ€, “TOâ€, “Bothâ€, “Yâ€)

Any ideas?
 
Back
Top