Using COUNTIF for Counting Words?

R

Rich B

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
 
D

Dave Peterson

=COUNTIF(B1:B100,"IN")

Maybe????

Rich said:
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
Click to expand...
 
N

Nick Danger

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
 
Top