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

Should I be using IF to find how many times a word occurs in a ran
 

=COUNTIF(B3:AF78,"Ruth")
Regards,
Stefi

€žruthie_toothy€� ezt Ã*rta:

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

Should I be using IF to find how many times a word occurs in a ran
 

Hi Ruth

Try:

=COUNTIF(B3:AF78,"Ruth")

"ruthie_toothy" wrote:

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

Should I be using IF to find how many times a word occurs in a ran
 

Hi Ruth

=COUNTIF($B$3:$AF$78,"Ruth")

If you are wanting to count several names, better to put the names in a cell
e.g. AG1, then use

=COUNTIF($B$3:$AF$78,AG1)
If you put other names in AG2, Ag3 etc, you can then just copy the formula
down.
--
Regards
Roger Govier

"ruthie_toothy" wrote in message
...
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

__________ Information from ESET Smart Security, version of virus
signature database 4245 (20090715) __________

The message was checked by ESET Smart Security.

http://www.eset.com




__________ Information from ESET Smart Security, version of virus signature database 4245 (20090715) __________

The message was checked by ESET Smart Security.

http://www.eset.com

Should I be using IF to find how many times a word occurs in a ran
 

Thank you all so much - that is perfect - just what I needed. I am over the
moon!


"ruthie_toothy" wrote:

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