先要看,你这三个区域是什么样的关系,如果是独立的,则可以用下面的公式将所有的满足条件的人数进行加总:我估计你第二个区域应该是G6:H31
=COUNTIF(C6:D31,">80")+COUNTIF(G6:H31,">80")+COUNTIF(K6:L31,">80")
先要看,你这三个区域是什么样的关系,如果是独立的,则可以用下面的公式将所有的满足条件的人数进行加总:我估计你第二个区域应该是G6:H31
=COUNTIF(C6:D31,">80")+COUNTIF(G6:H31,">80")+COUNTIF(K6:L31,">80")