| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cap Sensitive Countif
Is there a way to use the COUNTIF function in conjunction with a capital
sensitive criteria? In other words, I'd like to count cells that contain a capital "X", and differentiate that from a count of small "x". |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Cap Sensitive Countif
=SUMPRODUCT(--(EXACT(E1:E10,"X")))
-- Don Guillett Microsoft MVP Excel SalesAid Software "Tod H" wrote in message ... Is there a way to use the COUNTIF function in conjunction with a capital sensitive criteria? In other words, I'd like to count cells that contain a capital "X", and differentiate that from a count of small "x". |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Cap Sensitive Countif
This is an array formula which you enter by pressing ctrl-enter-shift
=SUMPRODUCT(--NOT(ISERROR(FIND("X",A7:A18)))) "Tod H" wrote: Is there a way to use the COUNTIF function in conjunction with a capital sensitive criteria? In other words, I'd like to count cells that contain a capital "X", and differentiate that from a count of small "x". |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I use case sensitive VLOOKUP? | Excel Worksheet Functions | |||
| Time Sensitive Formulas | Excel Discussion (Misc queries) | |||
| Case Sensitive w/ IF | Excel Worksheet Functions | |||
| How to set up a date sensitive notification? | Excel Discussion (Misc queries) | |||
| How to set up a date sensitive notification? | Excel Discussion (Misc queries) | |||
Hybrid Mode
