Thread: Should I be using IF to find how many times a word occurs in a ran
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ruthie_toothy ruthie_toothy is offline
external usenet poster
  
Posts: 1
Default Should I be using IF to find how many times a word occurs in a ran
Hi

I have an area B3:AF78 and I need to know how many times the word "Ruth"
appears within this range. Each cell only contains one name. I will need
this formula for a number of names within the range. I tried this formula
but it didnt work and I think I may be using the wrong formula completely.
Can anyone help at all.

=IF(B3:AF78="Ruth",1,0)

Many thanks
Ruth
Reply With QuoteReply With Quote