Counting cells in a schedule.

[Guest]

Hello Friends

Column A has the names of our employees
Column B has an indicator (*) next to each employee that has achieved a
certain accreditation i.e. able to perform a special skill.
The next 28 columns are the 4 week work schedule with symbols (D=day shift,
E=evenings, N=nights) indicating that employees status.

The problem:

I need the row at the bottom of the schedule portion to show the number of
employees on each day that have the special credentialing.

TIA for any assistance!

Sam

 

[Tom Ogilvy]

=SUM(($B$2:$B$30="*")*(C$2:C$30={"D","E","N"}))

Entered in C31 for example. This is an array formula, so enter it with
Ctrl+Shift+Enter rather than just enter