try
=COUNTIF(A1:A10,"camera")
where a1:a10 is the range where your data is held.
--
Ruthki
------------------------------------------------------------------------
Ruthki's Profile:
http://www.excelforum.com/member.php...o&userid=24503
View this thread:
http://www.excelforum.com/showthread...hreadid=386414