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
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