我有一张如下表:
问:我怎样才能计算全部Female Undergraduate
或Male Diploma
?
答案1
将这些公式放在某处
=COUNTIFS(B2:B25,"Male",C2:C25,"Diploma")
=COUNTIFS(B2:B25,"Female",C2:C25,"Undergraduate")
答案2
对于多条件计数使用COUNTIFS
函数,例如统计女大学生
=COUNTIFS(B:B,"Female",C:C,"Undergraduate")
COUNTIFS 需要 Excel 2007 或更高版本