Try something like this...

To count the number of cells in A1:A100 that contain "MyText":
=COUNTIF(A1:A100,"MyText")

Note: COUNTIF is not case-sensitive.


Does that help?

Regards,

Ron


--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419
View this thread: http://www.excelforum.com/showthread...hreadid=569882