| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using ? in criteria
I am trying to use a countifs function to count the ?'s in a column for a
particular category, i.e. countifs(A1:A10,"Workshop",B1:B10,"?"). However, it looks like the function is picking the ? as a wildcard because it is giving me a count of all entries with a single character. I have tried using "?" and referencing it in a cell. Any suggestions? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Using ? in criteria
Try...
=COUNTIFS(A1:A10,"Workshop",B1:B10,"~?") -- Domenic Microsoft Excel MVP www.xl-central.com Your Quick Reference to Excel Solutions In article , RyanH wrote: I am trying to use a countifs function to count the ?'s in a column for a particular category, i.e. countifs(A1:A10,"Workshop",B1:B10,"?"). However, it looks like the function is picking the ? as a wildcard because it is giving me a count of all entries with a single character. I have tried using "?" and referencing it in a cell. Any suggestions? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Using ? in criteria
Worked perfectly. Thank you very much.
"Domenic" wrote: Try... =COUNTIFS(A1:A10,"Workshop",B1:B10,"~?") -- Domenic Microsoft Excel MVP www.xl-central.com Your Quick Reference to Excel Solutions In article , RyanH wrote: I am trying to use a countifs function to count the ?'s in a column for a particular category, i.e. countifs(A1:A10,"Workshop",B1:B10,"?"). However, it looks like the function is picking the ? as a wildcard because it is giving me a count of all entries with a single character. I have tried using "?" and referencing it in a cell. Any suggestions? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Query criteria based on a changing criteria list | Excel Discussion (Misc queries) | |||
| EXCEL - Meet 2 criteria, then find next case of third criteria | Excel Worksheet Functions | |||
| =DMIN(database,field,criteria) question about criteria | Excel Discussion (Misc queries) | |||
| Counting Cells with multiple criteria.One criteria supporting wild | Excel Worksheet Functions | |||
| Counting Cells with multiple criteria.One criteria supporting wild | Excel Worksheet Functions | |||
Linear Mode
