The result is showing 11. The Countifsformula that Ive used in the above example counts the Name Apple in Column A if the corresponding values is Passed in Column B. In cell G2, insert the following REGEXREPLACE formula to remove the equal signs from the FORMULATEXT result. Now, we will add a column named Result in the data set to show the result. I love traveling, reading books, playing cricket. Let's break this COUNTA function down: In this section, well combine the COUNTBLANK function with the COUNTIF function. We will get our most desired output from here. It is working as desired. SEARCH(find_text, text, position) find_text: The string to find.
