Counting cells in a schedule.
 

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

Counting cells in a schedule.
 

=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

--
Regards
Tom Ogilvy


"Metolius Dad" wrote in message
...
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