Hi I need a formula that counts cells beyond the formula =COUNTIFS(A:A,"Blue",D:D,"On time") that accounts for duplicates. Any help would be appreciated =)
Row 2 (Blue/Unique#/Late) should be counted in H2
Row 3 (Blue/Unique#/On time) should be counted in G2
Row 4 and 5...