Counting cell that have numbers in the string

[SeniorTom]

I'm trying to count the cell that have a number embedded in the string:

<tbody>
[TD="class: xl69"]11/10/2016[/TD]
[TD="class: xl69, width: 102"]11/14/2016[/TD]
[TD="class: xl69, width: 102"]11/17/2016[/TD]
[TD="class: xl69, width: 97"]11/21/2016[/TD]
[TD="class: xl70, width: 92"]11/24/2016[/TD]

</tbody>

<tbody>
[TD="class: xl69"]1zSMITH[/TD]
[TD="class: xl68, width: 102"]2zSMITH[/TD]
[TD="class: xl68, width: 102"]SMITH[/TD]
[TD="class: xl67, width: 97"]SMITH3[/TD]
[TD="class: xl68, width: 92"]x4zSMITH
[/TD]

</tbody>

I can count if the Number is 1st or last but am having problems when the are embedded. The date cells are not of concern.

Any thought would be appreciated.
Regards,
Tom

 

[NiMip]

Assuming your text cells are starting in A2:
=SUM(IF(ISNUMBER(SEARCH({0;1;2;3;4;5;6;7;8;9},A2:E2)),1,0))

Pressing CONTROL+SHIFT+ENTER as it's an array formula... you should see {} appear around the formula if done correctly.

 

[SeniorTom]

Thank NiMIP! It did the job.

Tom