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

Leave a Reply