=COUNTIF($B$4:$AO$25,CHAR(97)) for "a"
=COUNTIF($B$4:$AO$25,CHAR(65)) for "A"

Regards,
Stefi

€želite€� ezt Ã*rta:


I have an worksheet that counts the number of cells containing a certain
letter:

E.g.
Code:
--------------------
=(COUNTIF($B$4:$AO$25,"a"))
--------------------


I would like to make this case sensitive so I can return the number of
lowercase 'a' and the number of uppercase 'A'

Thanks for any help


--
elite
------------------------------------------------------------------------
elite's Profile: http://www.excelforum.com/member.php...o&userid=27394
View this thread: http://www.excelforum.com/showthread...hreadid=469123