Home » Posts

Count cells that contain case sensitive

To count cells that contain specific text (i.e. contain a substring), taking into account upper and lower case, you can use a formula based on the ISNUMBER and FIND functions, together with the SUMPRODUCT function. In the example shown, E5 contains this formula, copied down: =SUMPRODUCT(--ISNUMBER(FIND(D5,data))) Where data is the named range B5:B15. The result is a case-sensitive count of each substring listed in column D.

April 14, 2025 · 1 min · 45 words · Nathaniel Mayo

Because we give FINDmultiplevalues in thewithin_textargument, it returnsmultipleresults.

represents a value in B5:B15 that does not contain “ABC”.

Looking more closely, we can see that FIND found “ABC” in 4 cells out of 11.

Excel formula: Count cells equal to case sensitive