west666
幼苗
共回答了13个问题采纳率:92.3% 举报
一般用的SUMPRODUCT函数,格式为:
=SUMPRODUCT((条件1)*(条件2)*(条件3)*.(条件N))
公式如下:
2-4米投掷距离中,40-49岁的有多少人,公式:
=SUMPRODUCT((B2:B999>=40)*(B2:B999<=49)*(C2:C999>=2)*(C2:C999<=4))
如果用的是EXCEL 2007及以上版本,公式精简为:
=COUNTIFS(B:B,">=40",B:B,"<=49",C:C,">=2",C:C,"<=4")
2-4米投掷距离中,30-39岁的有多少人,公式:
=SUMPRODUCT((B2:B999>=30)*(B2:B999<=39)*(C2:C999>=2)*(C2:C999<=4))
如果用的是EXCEL 2007及以上版本,公式精简为:
=COUNTIFS(B:B,">=30",B:B,"<=39",C:C,">=2",C:C,"<=4")
1年前
1