Try this:

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

Then copy across as needed.

Biff

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

Need more info!

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

How do you denote if an employee is working?

Biff

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