Y
Yvonne
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.
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.