Thread: Count Number of Times Something appears
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mark B
 
Posts: n/a
Default Count Number of Times Something appears
=COUNTIF(Sheet2!A:A,B1)

Thanks Bob, that's great...
Reply With QuoteReply With Quote