Count Number of occurences of several texts in a range of cells
Try this
=SUMPRODUCT(--(ISNUMBER(SEARCH({"S&D","TO","Both","Y"},O2:O93))) )
Mike
"kbeirne" wrote:
Im 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.
Ive tried these but they wont 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?
|