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
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks