How to count lower case alphabet?
 

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.

How to count lower case alphabet?
 

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.

How to count lower case alphabet?
 

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

How to count lower case alphabet?
 

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

How to count lower case alphabet?
 

Thanks Luke, so amazing.

"Luke M" wrote:

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

How to count lower case alphabet?
 

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.

How to count lower case alphabet?
 

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

"Gary''s Student" wrote:

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

How to count lower case alphabet?
 

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"Yvonne" wrote in message
...

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.

How to count lower case alphabet?
 

"99" is ASCII code for "c".

Yvonne wrote:

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

"Gary''s Student" wrote:


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