计算机用excel肿么求及格率

不能这么写，你要么给E:G列移到A:C列去统一写 要么=(countif(c3:c7,"60")+countif(g3:g6,"60"))/(count(c3:c7)+count(g3:g6))