Array tally

[Guest]

Dear Wizards,

Typical company schedule, Employee's names in col a, 28 day schedule starts
out in col e as day one. I've figured how to tally the number of employees
at the bottom of the columns to see how many are on each day.
Situation: Some of the employees are certified and I've place an asterisk
next to their name on col 'b'. How do I make another tally row at the bottom
of the schedule grid that tells me how many 'certified' employees are on for
each day?

TIA for your help.
Sam

 

[T. Valko]

Need more info!

Column A = names
Column B = "*" or empty?

How do you denote if an employee is working?

Biff

 

[Guest]

Sorry about that Biff. Good and important question though. I'm designating
their workdays with a few different alphanumerics i.e. 1, 2, L, e2, r/o which
I want all considered when doing this certification count BUT I've also got
some non-working alphanumerics which I don't want considered like v
(vacation), f (FMLA) etc. And yes, you're right, col b will be "*" or empty.

Again, thanks for any help.
Sam

 

[T. Valko]

Try this:

=SUMPRODUCT(($B2:$B10="*")*(C2:C10={1,2,"L","E2","R/O"}))

Then copy across as needed.

Biff