一、同列統計 =COUNTIF(C2:C130,"財務部")
二、同列多條件計數
=SUM(COUNTIF(C2:C131,{"財務部","後勤部"}))
=COUNTIF(C2:C130,"財務部")+COUNTIF(C2:C130,"後勤部")
三、多列計數
=COUNTIFS(C2:C130,"後勤部",D2:D130,"主任")
閱讀更多 淡墨留餘香 的文章
2018-06-10 18:59:28 淡墨留餘香
一、同列統計 =COUNTIF(C2:C130,"財務部")
二、同列多條件計數
=SUM(COUNTIF(C2:C131,{"財務部","後勤部"}))
=COUNTIF(C2:C130,"財務部")+COUNTIF(C2:C130,"後勤部")
三、多列計數
=COUNTIFS(C2:C130,"後勤部",D2:D130,"主任")
閱讀更多 淡墨留餘香 的文章