Forum Discussion
Count cells considering uppercase and lowercase
I want to Count cells considering uppercase and lowercase. Example count for separately letter A and a , B and b .... but i don't have formula for this, because Countif don't differentiate between ...
If the range to be evaluated is in Column A and the criteria to be compared is in B1, the formula for a case-sensitive count is:
=SUMPRODUCT(--EXACT(A:A,B1))
=SUMPRODUCT(--EXACT(A:A,B1))