Hi,

Assuming that the data is in the range A1 to B100, and the person to
whom you want the count is listed in cell C1, use this formula

=SUMPRODUCT(($A$1:$A$100=C1)*(B1:B100="Off"))

Regards

Govind.

ashstudly wrote:
Supervisor Sun
Adam S Mower 11:00-16:00
Adam S Mower 11:00-19:30
Adam S Mower Off
Adam S Mower 8:30-13:30
Candice S Carter Off
Candice S Carter Off
Candice S Carter 8:00-16:30
Chris S Uigaese 8:00-13:00
Chris S Uigaese Off
Chris S Uigaese 12:00-20:00
Chris S Uigaese 8:00-16:30
Chris S Uigaese 8:00-16:30


I'm trying to make a formula that autmatically counts the number of
"off"'s that appear in the chart above that are listed with a certain
person... I just can't seem to come up with the function. Above is an
example. The names are in a separate column. Any help?