原来的公式为:countifs(N6:Z6,I3,N8:Z22,I1)加粗的部分错误:更正为:countifs(N6:Z22,I3,N6:Z22,I1)如有疑问可以继续交流!
=COUNTIFS(B2:B10,"广州",C2:C10,">=3",D2:D10,">20")