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