excel函数(办公软件）高手请进！

=sumproduct((c1:c14="男生"）*(e1:e14="上海")) 最高=SUMPRODUCT((MAX((c1:c14="女")*(e1:e14)))) 最低=SUMPRODUCT((LARGE((c1:c14="女")*(e1:e14),COUNTIF(c1:c14,"女"))))