Thread: How do you count number of times Fred Smith appears in a list
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Matt Matt is offline
external usenet poster
  
Posts: 516
Default How do you count number of times Fred Smith appears in a list
=COUNTIF(Data Range, "Fred Smith")

"Geoff" wrote:

I'm trying to count the number of times a sales persons name (Fred Smith)
appears in several columns of a work sheet.
Reply With QuoteReply With Quote