Hi again,

I'd like to have a cell count the number of times it sees %100 in a particular column, only if it matches a certain criteria (ie, the name of the shift)

You'll see in the attached file

book4.xls