UC知道在Excel中,学生同一科成绩分别填在c f i l四列,怎样能一次筛选出80分以上的学生人数,并显示在G3格.
来源：百度知道 编辑：UC知道 时间：2024/06/08 16:57:29
请高手赐教:在Excel中,学生同一科成绩分别填在C6:C20 F6:F20 I6:I20 L6:L20四列,怎样能一次筛选出80分以上的学生人数,并显示在G3格.谢谢!
在G3单元格输入
=COUNTIF(C6:C20,">80")+COUNTIF(F6:F20,">80")+COUNTIF(I6:I20,">80")+COUNTIF(L6:L20,">80")
=SUM((C6:C20>80)*1)+SUM((F6:F20>80)*1)+SUM((I6:I20>80)*1)+SUM((L6:L20>80)*1)
以ctrl+shift+回车结束输入，就可以得到数量。
在G3格输入:=COUNTIF(C6:L20,">80")即可!
=COUNTIF(C6:C20,">80")+COUNTIF(F6:F20,">80")+COUNTIF(I6:I20,">80")+COUNTIF(L6:L20,">80")