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 A and a. I need help with that
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))
