Thread: Help Needed With Count
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.newusers
Claus Busch Claus Busch is offline
external usenet poster
  
Posts: 3,872
Default Help Needed With Count
Hi,

Am Tue, 4 Sep 2012 06:14:55 -0700 (PDT) schrieb :

Yes the character may appear more than once in a cell.

try:
=COUNTIF(B4:C25,"*&*")


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2
Reply With QuoteReply With Quote