Thread
:
Cap Sensitive Countif
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Don Guillett
external usenet poster
Posts: 10,124
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".
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett