countif question for a rota

[Guest]

I have rota which has all the departments in column A and the days of the
week going along the top. I would like to do a countif to automatically count
how many days a particular person is working. However, a problem arises if
the person is working in 2 departments in 1 day. In this situation the count
will come up as 2 days worked. How do I stop this and make it just count 1?

 

[Frank Kabel]

Hi
could you post your existing formula

 

[sulprobil]

Enter 0.5 into each department cell for this person and
apply a conditional format to show that a person was in at
a given weekday.

I bet your next task will be to present a list of % people
were working for a department. Then you will have either
hours or parts of a day (0.5 like mentioned above) to be
entered in the cells

Regards,
sulprobil

 

[Guest]

The formula I'm using is
=COUNTIF(D$3:J$28,"*GB*")

(Where GB is the staff's initials)

Hi
could you post your existing formula

 

[Guest]

Don't worry! I've done a quite longwinded sum of ifs and countifs which is
messy, but works!

The formula I'm using is
=COUNTIF(D$3:J$28,"*GB*")

(Where GB is the staff's initials)

 

[Frank Kabel]

Hi
why not post your working formula for 'shortening'