Try this:

=SUM(--(FREQUENCY(IF((A2:A29="Active")*(B2:B29="Williams")*(D2:D29="Slab"),MATCH(C2:C29,C2:C29,0)),ROW(C2:C29)-ROW(C2)+1)>0)) Ctrl Shift Enter