|
Count Number of occurences of several texts in a range of cells
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? |
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? |
Count Number of occurences of several texts in a range of cell
Worked GREAT! Thaks.
"Mike H" wrote: 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? |
Count Number of occurences of several texts in a range of cell
Glad I could help and thanks for the feedback
"kbeirne" wrote: Worked GREAT! Thaks. "Mike H" wrote: 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? |
| All times are GMT +1. The time now is 05:06 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com