預定日期 可知空房否 (13989)

I2:I6=IFERROR(LOOKUP(1,0/(B:B=F$2)/(D:D=H2),C:C),"")

A2 下拉=IF(C2="","",COUNTIFS(B$2:B2,B2,D$2:D2,D2))