You could use a helper column inserted to the right of your range and
the GET.CELL macro. First define a name "ShowFormula" using the
following reference.

=GET.CELL(6,INDIRECT("RC[-1]",FALSE))

In the first cell of the helper column type the formula =ShowFormula
and copy down your range. This will populate that with the formula of
the cell to the left. Then you can use the COUNTIF funtion. So say
your range to find the formula is A1:A10 and your helper column is
B1:B10 then:

=COUNTIF(B1:B10,"*CEILING*)


Does that help?

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=546764