第1个回答 2011-04-25
=COUNTIF(J4:J11,"优秀")/COUNTA(J4:J11)
=COUNTIF(C4:C11,"男")/COUNTA(C4:C11)
=COUNTIF(C4:C11,"女")/COUNTA(C4:C11)
单元格设为百分比格式。
第2个回答 2011-04-25
优秀率 =COUNTIF(J4:J11,"优秀")/count(J4:J11)*100%
男生比例 =countif(C4:C11,"男")/count(c4:c11)*100%
女生比例 =countif(C4:C11,"女")/count(c4:c11)*100%