Count the the range of column with undetermined criteria

dear experts

i want count the particular two criteria with date and blank from main criteria range!!!

like i have similar two set of data ZLAB AND ZSP1 In the column C:C and In column B & D .....have different data's i want count date ,so's and blank


FIND THE ATTACHMENT

the countifs() did the trick

in F5: =COUNTIF($C2:$C24,"="&F4)-F6
in G5: =COUNTIF($C2:$C24,"="&G4)-G6
in F6: =SUMPRODUCT(IF(C2:C24=F4,1),IF(D2:D24="",1))
in G6: =SUMPRODUCT(IF(C2:C24=G4,1),IF(D2:D24="",1))
in F7: F5+F6
in G7: G5+G6

F6 and G6 are array formulas so need to be confirmed with ctrl+shift+enter

thanks for solution and being spend time for my post!!! solved