高手求助,EXCEL公式,在A列选择时间段区间,对B列相应的数字求平均或求...答:1、=COUNTIFS(L:L,">="&DATE(YEAR(G1),MONTH(G1),1),L:L,"<"&DATE(YEAR(G1),MONTH(G1)+1,1))2、=AVERAGEIFS(P:P,L:L,">="&DATE(YEAR(G1),MONTH(G1),1),L:L,"<"&DATE(YEAR(G1),MONTH(G1)+1,1))3、=COUNTIFS(L:L,"",M:M,">2")公式适用于2007以上版本 ...