Explanation

By default, Excel isnotcase-sensitive.

Excel formula: Case sensitive lookup

Excel formula: Count cells equal to case sensitive

Excel formula: SUMPRODUCT case-sensitive lookup

Excel EXACT function