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".

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".

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".