Countif Criteria For One Or More Numeric Value In A String

Let’s see how we could use countif formula to count the number of rows that contain at least one numeric value anywhere.

We will use the countif formula with wildcard operator.

Capture

Above is the data in column A which has three cells that contain at least one numeric value in it.

I have written a formula using sum and countif with the criteria that atleast one numeric value is available.

Enter the formula below to get the count of those records.




=SUM(COUNTIF(A:A, “*”&{0,1,2,3,4,5,6,7,8,9}&”*”))

Capture

As you could see the result is 3(As rows 2, 3 and 6 contain numeric value).

Hope this helped.

Share The Knowledge

Random Posts

  • Vlookup First Word In Excel

    In this post we will see how could we vlookup for first word in a string, here string could be […]

    Share The Knowledge
  • Check If A Cell Has An Error In Excel

    No matter how much we hate errors they seem to be inevitable.Sometimes dynamically we are required to check the cells if […]

    Share The Knowledge
  • Delete Every Column Except Some Column In Excel

    loop through excel columns and delete all but keep some, delete all columns in excel except some, excel vba to loop and delete some columns, delete some columns in excel while keeping some columns

    Share The Knowledge
  • Fit Image Inside A Shape In Excel

    In this post we will see how to fill a shape with image in excel. I am going to explain […]

    Share The Knowledge

Leave a Reply