MINIFS和MAXIFS
=MAX(IF(B2:B10=E2,C2:C10))
=MAXIFS(C:C,B:B,E2)
=MINIFS(C:C,B:B,E2)
=MAXIFS(D:D,B:B,F2,C:C,G2)
=MAXIFS(D:D,B:B,F2,C:C,G2,A:A,">=2019-11-1")
赞 (0)
=MAX(IF(B2:B10=E2,C2:C10))
=MAXIFS(C:C,B:B,E2)
=MINIFS(C:C,B:B,E2)
=MAXIFS(D:D,B:B,F2,C:C,G2)
=MAXIFS(D:D,B:B,F2,C:C,G2,A:A,">=2019-11-1")