On Tue, 20 Sep 2005 05:53:54 -0500, elite
wrote:


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


The FIND worksheet function is case sensitive, and will return a number if the
string in question is found (otherwise it returns a VALUE error).

So:

=SUMPRODUCT(--ISNUMBER(FIND("A",rng)))
=SUMPRODUCT(--ISNUMBER(FIND("a",rng)))

should give you your count. The only caveat is that you cannot refer to an
entire column in your cell reference.


--ron