Suksesjib

 This formula can replace all later formulas in this article except the formula to count the number of words in a cell Example 1 Counting the Number of Occurrences of a Text String in a Range Start Excel, and then open a new workbook Type the following on sheet1 Answers text/html PM Colin Banfield 1 1 Sign in to vote Imke's formula works if 1) You have a table with column names Column1 and Column2 2) Column2 has the text that you want to count in Column1 (in part or in whole) 3) The previous step before you add the custom column is named Source The first is, instead of using curly brackets you need to use a named range (best way is to use table) of your values And after that, you need to enter this formula by using Ctrl Shift Enter as a proper array formula So, now your formula will be {= SUM ( COUNTIFS (B2B51,Named_Range))} Excel Formula Count Cells That Contain Numbers Exceljet Countifs function in excel 2016