How to count lower case alphabet?

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.
 
L

Luke M

You can use this array* formula

=SUM(EXACT("c",A1:B5)*1)

*Use Ctrl+Shift+Enter to confirm formoula, not just Enter.
 
Y

Yvonne

Thanks Luke, so amazing.

Luke M said:
You can use this array* formula

=SUM(EXACT("c",A1:B5)*1)

*Use Ctrl+Shift+Enter to confirm formoula, not just Enter.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top