Countifs problem

[shjoaquin]

I am not sure if I am using the correct formula, but I am trying to answer the following question.

I am trying to add coordinators on day shift (c$2:c$470,"d*") that work in the bay area (d$2:d$470,"b*") and were notified prior to their shift starting (h$2:h$470,"y*")...

Here is the forumla I am using:
=countifs(c$2:c$470,"d*",d$2:d$470,"b*",h$2:h$470,"y*")


When I calculate each coordinator individually for all shifts it works out, but the sums at the bottom by individual shift do not add up.

Thanks for any help,
Shawna

 

[shjoaquin]

Good ideas, can you tell me how to do that?