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