Biff wrote...
....
=SUMPRODUCT(--(ISNUMBER(FIND("9",A1:B12))))0
....

If you're willing to put up with an array formula,

=COUNT(FIND(9,range))0