Home

Count cells considering uppercase and lowercase

%3CLINGO-SUB%20id%3D%22lingo-sub-659683%22%20slang%3D%22en-US%22%3ECount%20cells%20considering%20uppercase%20and%20lowercase%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-659683%22%20slang%3D%22en-US%22%3E%3CP%3EI%20want%20to%26nbsp%3BCount%20cells%20considering%20uppercase%20and%20lowercase.%20Example%20count%20for%26nbsp%3B%3CSPAN%3Eseparately%20letter%20A%26nbsp%3B%20and%20a%20%2C%20B%20and%20b%20....%20but%20i%20don't%20have%20formula%20for%20this%2C%20because%20Countif%20don't%26nbsp%3Bdifferentiate%20between%26nbsp%3B%20A%20and%20a.%20I%20need%20help%20with%20that%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-659683%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20Online%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-659741%22%20slang%3D%22en-US%22%3ERe%3A%20Count%20cells%20considering%20uppercase%20and%20lowercase%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-659741%22%20slang%3D%22en-US%22%3EIf%20the%20range%20to%20be%20evaluated%20is%20in%20Column%20A%20and%20the%20criteria%20to%20be%20compared%20is%20in%20B1%2C%20the%20formula%20for%20a%20case-sensitive%20count%20is%3A%3CBR%20%2F%3E%3DSUMPRODUCT(--EXACT(A%3AA%2CB1))%3C%2FLINGO-BODY%3E
amaroe
Occasional Visitor

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

1 Reply
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))
Related Conversations
Extentions Synchronization
Deleted in Discussions on
3 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
35 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
9 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies