How to count lower case alphabet?

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

 

[T. Valko]

Try this:

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

 

[Luke M]

You can use this array* formula

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

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

 

[Gary''s Student]

=SUMPRODUCT(--(CODE(A1:B5)=99))

 

[Yvonne]

Thanks Luke, so amazing.

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!*

 

[Yvonne]

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

Try this:

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

 

[Yvonne]

Hi Gary's Student,
It works. Thanks. What's 99 stands for?

 

[T. Valko]

You're welcome. Thanks for the feedback!

 

[Bob I]

"99" is ASCII code for "c".

Hi Gary's Student,
It works. Thanks. What's 99 stands for?

: