SUMPRODUCT((LEFT($D$2:$D$30,1)=LEFT(G$4,1))*(--RIGHT($C$2:$C$30,2)=ROUNDUP(COLUMN(A1)/5,0)+14)*($A$2:$A$30=$F5)*$B$2:$B$30)
违约需要承