=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