統計 房型 日期數 (10874)

F3:J8=IF((F$2>=$C3)*(F$2<$D3),1,"")

C15:G17=SUMPRODUCT(($E$3:$E$8=$B15)*($F$2:$J$2=C$14)*(0&$F$3:$J$8))

另解C15:G17=SUMPRODUCT(($B$3:$B$8=$B15)*($C$3:$C$8<=C$14)*($D$3:$D$8>C$14))