Tell the difference between upper and lower case

R

RogerDaShrubber

I have a column that has letters in it and I am using

=COUNTIF(D13:D27,"M") in one cell

and

=COUNTIF(D13:D27,"m") in another.

to keep track of what letters are put in the "D" column. But the
both count the upper AND lowercase letters. Is there any way to mak
excel tell the difference between upper and lowercase letters?

Thanks
Ro
 
H

hgrove

RogerDaShrubber wrote...
...
=COUNTIF(D13:D27,"M") in one cell

and

=COUNTIF(D13:D27,"m") in another.

to keep track of what letters are put in the "D" column. But
they both count the upper AND lowercase letters. Is there any
way to make excel tell the difference between upper and
lowercase letters?
Click to expand...

Yes, but not using COUNTIF. COUNTIF is always case-insensitive.

Try

=SUMPRODUCT(--EXACT(D13:D27,"M"))

and

=SUMPRODUCT(--EXACT(D13:D27,"m")
 
P

Paul B

Rog, here is one way
=SUMPRODUCT((EXACT(C13:D27,"M")*1))
=SUMPRODUCT((EXACT(C13:D27,"m")*1))

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 97
** remove news from my email address to reply by email **
 
Top