在B2中输入或复制粘贴下列公式=COUNTIFS(表1!$G:$G,$A2,表1!$B:$B,">="&INDIRECT("H"&COLUMN(B2)),表1!$B:$B,"<="&INDIRECT("H"&COLUMN(B2)))下拉填充
G2:G28应为$G$2:$G$28
