View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
jermsalerms
 
Posts: n/a
Default Added up # of cells containing a specified word


In cell A1 I would like to have a formula that indicates the number of
times the word "Yellow Pages" appears in cells C10:C1000. The C column
inidicates a referral source. So some of the cells will have "Yellow
Pages" and some wont. In cell A1 I would like to have it tell me the
total # of referrals from the lead source "Yellow Pages". Any
suggestions?


--
jermsalerms
------------------------------------------------------------------------
jermsalerms's Profile: http://www.excelforum.com/member.php...o&userid=30167
View this thread: http://www.excelforum.com/showthread...hreadid=516297