Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting number of times a value occurs | Excel Discussion (Misc queries) | |||
How do I calculate times each word occurs in a column of cells? | Excel Worksheet Functions | |||
I want to see how many times each number occurs in an array. | Excel Discussion (Misc queries) | |||
Using COUNTIF to find how many times 2004 occurs | Excel Worksheet Functions | |||
I would like to count the # of times a value occurs in Col B base | Excel Worksheet Functions |