Excel Countif Partial String Match

Kyle Nov 07, 2026
How to Perform Partial Match of String in Excel (8 Easy Methods) - ExcelDemy
How to Perform Partial Match of String in Excel (8 Easy Methods) - ExcelDemy

Count cells that contain a specific substring (partial match)

COUNTIF formulas to find and count duplicates in 1 column

How to Perform Partial Match of String in Excel (8 Easy Methods) - ExcelDemy
How to Perform Partial Match of String in Excel (8 Easy Methods) - ExcelDemy

Excel Count Partial Text Match

INDEX MATCH is a powerful combination that allows you to do simple and advanced lookups in Excel. In this article, I'll show you 10 examples of using this.

Advanced Excel Formulas - Index Match

Excel: If cell contains then count, sum, highlight, copy or delete
Excel: If cell contains then count, sum, highlight, copy or delete
Excel VBA to Match String in Column (5 Examples) - ExcelDemy
Excel VBA to Match String in Column (5 Examples) - ExcelDemy

Excel If Partial String Match

How to Use the COUNTIF Function for Partial Matches in Excel (3 Methods) - ExcelDemy
How to Use the COUNTIF Function for Partial Matches in Excel (3 Methods) - ExcelDemy
Excel SUMIF with Partial Match (3 Easy Ways) - ExcelDemy
Excel SUMIF with Partial Match (3 Easy Ways) - ExcelDemy

Excel Countif Not Match String

Partial Match Excel - ExcelDemy
Partial Match Excel - ExcelDemy
Excel COUNTIF function examples - not blank, greater than, duplicate or unique
Excel COUNTIF function examples - not blank, greater than, duplicate or unique
How to count total matches in two ranges - Excel Formula
How to count total matches in two ranges - Excel Formula
Excel Formula to Split String by Comma (5 Examples) - ExcelDemy
Excel Formula to Split String by Comma (5 Examples) - ExcelDemy
How to Apply the COUNTIF Function When a Cell Contains Specific Text - 3 Methods - ExcelDemy
How to Apply the COUNTIF Function When a Cell Contains Specific Text - 3 Methods - ExcelDemy
How to Find Partial Match in Two Columns in Excel (4 Methods) - ExcelDemy
How to Find Partial Match in Two Columns in Excel (4 Methods) - ExcelDemy
Excel VBA: Split String into Cells (4 Useful Applications) - ExcelDemy
Excel VBA: Split String into Cells (4 Useful Applications) - ExcelDemy
Excel String Tricks: Unravel the Opposite of Concatenate Function in Excel
Excel String Tricks: Unravel the Opposite of Concatenate Function in Excel
INDEX & MATCH Functions Combo in Excel (10 Easy Examples)
INDEX & MATCH Functions Combo in Excel (10 Easy Examples)
Advanced Excel Formulas for Financial Analysts and Power Users
Advanced Excel Formulas for Financial Analysts and Power Users