Hi Harlan,

You know, I was trying to cobble together an array formula on my own before I decided I was not on the right track. At least I
thought that an array formula would be the path of least resistance...just couldn't make it work.

Thanks, Harlan !!

Richard

--
RMC,CPA


"Harlan Grove" wrote in message oups.com...
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