Count cells equal to case sensitive version in Excel
Disclosure: I earn a commission from the link below, which helps support my content creation. Thanks for your support!
Take Excel classes with 1 free month of Skillshare (paid link) https://www.skillshare.com/en/r/profi...
Count cells equal to case sensitive version in Excel. See the formula below:
=SUMPRODUCT((--EXACT($C$7,$A$7:$A$11)))