=SUMPRODUCT(--(CODE(A1:B5)=99))
--
Gary''s Student - gsnu200848


"Yvonne" wrote:

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.