Simpler version for if all the data is in column A:
=SUM(IF(ISNUMBER(SEARCH("3",A:A)),1,0))
(Just change A:A to whatever range you need. This adds 1 for every cell in the range that contains a 3 and returns the result.)