三條件符合人數 (9683)


D3=COUNTIFS(A:A,"*张*",B:B,"男",C:C,">25")


D4{=COUNT(FIND("张",A3:A9)/(B3:B9="男")/(C3:C9>25))


留言