| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
LEFT(text,num_chars)
I have been using the following to count the number of occurances of the word
"Vacant" in several ranges of cells: =SUM(COUNTIF($B$8:$B$55,"Vacant"))+(COUNTIF($J$8:$ J$55,"Vacant"))+(COUNTIF($R$8:$R$55,"Vacant")) However, now I would like to count the number of occurances beginning with "Vacant" in several ranges of cells. I just cannot seem to get my arms around how to introduce the LEFT command into this formula. Any assistance is very much appreciated. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
LEFT(text,num_chars)
Try replacing...
"Vacant" with "Vacant*" Hope this helps! In article , Bigfoot17 wrote: I have been using the following to count the number of occurances of the word "Vacant" in several ranges of cells: =SUM(COUNTIF($B$8:$B$55,"Vacant"))+(COUNTIF($J$8:$ J$55,"Vacant"))+(COUNTIF($R$ 8:$R$55,"Vacant")) However, now I would like to count the number of occurances beginning with "Vacant" in several ranges of cells. I just cannot seem to get my arms around how to introduce the LEFT command into this formula. Any assistance is very much appreciated. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
LEFT(text,num_chars)
Man, was I making it more difficult than it needed to be. Much appreciated.
"Domenic" wrote: Try replacing... "Vacant" with "Vacant*" Hope this helps! In article , Bigfoot17 wrote: I have been using the following to count the number of occurances of the word "Vacant" in several ranges of cells: =SUM(COUNTIF($B$8:$B$55,"Vacant"))+(COUNTIF($J$8:$ J$55,"Vacant"))+(COUNTIF($R$ 8:$R$55,"Vacant")) However, now I would like to count the number of occurances beginning with "Vacant" in several ranges of cells. I just cannot seem to get my arms around how to introduce the LEFT command into this formula. Any assistance is very much appreciated. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
LEFT(text,num_chars)
=COUNTIF(B8:R55,"Vacant*")
or =SUMPRODUCT(--(LEFT(B8:R55,6)="Vacant")) "Bigfoot17" wrote: I have been using the following to count the number of occurances of the word "Vacant" in several ranges of cells: =SUM(COUNTIF($B$8:$B$55,"Vacant"))+(COUNTIF($J$8:$ J$55,"Vacant"))+(COUNTIF($R$8:$R$55,"Vacant")) However, now I would like to count the number of occurances beginning with "Vacant" in several ranges of cells. I just cannot seem to get my arms around how to introduce the LEFT command into this formula. Any assistance is very much appreciated. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Hybrid Mode
