| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Using COUNTIF for Counting Words?
Hi Gents...
First post here! I have a staff list in Excel where each employee has either IN or OUT stored in a cell relating to each day of the week... I need to count, for each day, how many INs there are amongst the staff, and also how many OUTs there are... I've tried using the following formula:- =COUNTIF(B1:B100,IN) To try and count the instances of the word IN from that column but always get the answer "0" appear... What am I doing wrong? :huh: Cheers Rich |
|
#2
|
|||
|
|||
|
=COUNTIF(B1:B100,"IN")
Maybe???? Rich B wrote: Hi Gents... First post here! I have a staff list in Excel where each employee has either IN or OUT stored in a cell relating to each day of the week... I need to count, for each day, how many INs there are amongst the staff, and also how many OUTs there are... I've tried using the following formula:- =COUNTIF(B1:B100,IN) To try and count the instances of the word IN from that column but always get the answer "0" appear... What am I doing wrong? :huh: Cheers Rich -- Rich B -- Dave Peterson |
|
#3
|
|||
|
|||
|
The first response (below) might work... I use something similar
although I put a wildcard before and after the text string : =countif(B1:B100,"*IN*") Regards Ben/ND On Thu, 08 Sep 2005 14:04:36 -0500, Dave Peterson wrote: =COUNTIF(B1:B100,"IN") Maybe???? Rich B wrote: Hi Gents... First post here! I have a staff list in Excel where each employee has either IN or OUT stored in a cell relating to each day of the week... I need to count, for each day, how many INs there are amongst the staff, and also how many OUTs there are... I've tried using the following formula:- =COUNTIF(B1:B100,IN) To try and count the instances of the word IN from that column but always get the answer "0" appear... What am I doing wrong? :huh: Cheers Rich -- Rich B |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| triadic combinations of words | Excel Worksheet Functions | |||
| Spell Checking - Special Words Not Picked Up by Excel | Excel Discussion (Misc queries) | |||
| Combining IF and COUNTIF based on two columns | Excel Discussion (Misc queries) | |||
| COUNTIF text where there is more than one word in a cell | Excel Worksheet Functions | |||
| Countif - Countif | Excel Worksheet Functions | |||
Linear Mode
