| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count number of occurences within a time range | Excel Discussion (Misc queries) | |||
| COUNT function - # of occurences a number appears in all cells | Excel Discussion (Misc queries) | |||
| Question about count ONLY different Texts in a range. | Excel Discussion (Misc queries) | |||
| How to count the occurences in my range with 2 characters only? | Excel Worksheet Functions | |||
| How do I count the number of alpha occurences in a range? | Excel Worksheet Functions | |||
Linear Mode
