Counting the number of cells which contain a specific character
Figured it out.

A glitch in the COUNTIF functions prevents it from working with numbers.  This could be easily fixed by the Excel function TEXT() but Numbers doesn't have that function. So...

To solve select B9:J9 and change the Data Format, in the Cell submenu, from Automatic to Text. Then use the function =COUNTIF(B9:J9,”*1*”) to count the amount containing the number. 

Screenshot showing formula when cells formatted as text:



Setting the cell format to text: