View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Don Guillett Don Guillett is offline
external usenet poster
 
Posts: 10,124
Default 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".