如题所述
看看我的截图,帮我解答下,谢了亲
不好意思,刚才才看见,如果你全部要用countif函数的话,可以这样试试人数栏:L12输入=COUNTIF(F3:F100,">=580")M12输入=COUNTIF(F3:F100,">=530")-L12N12输入=COUNTIF(F3:F100,"=!")