EXCEL,能同时满足条件:B列=1或2,D列=2,F列=10~17的行,并统计出本表格...答:2003以下版本输入 =SUMPRODUCT(((B2:B10000=1)+(B2:B10000=2))*(D2:D10000=2)*(F2:F10000>=10)*(F2:F10000<=17))2007以上版本输入 =COUNTIFS(B:B,1,D:D,2,F:F,">=10",F:F,"<=17")+COUNTIFS(B:B,2,D:D,2,F:F,">=10",F:F,"<=17")...