Thanks Valko, your method works best!!!!!


"T. Valko" wrote:

Try this:

=SUMPRODUCT(--(EXACT(A1:B5,"c")))

--
Biff
Microsoft Excel MVP


"Yvonne" wrote in message
...
Hi there, I need someone help to do the following:

Column A Column B
1 a A
2 B b
3 C C
4 c c
5 D e

=COUNTIF(A1:B5,"c") will give a result (4), but I only want to count the
lower case c which should give me a result (2) instead.

Thanks. Awaiting for an answer.