61阅读

lse；N(D2>={0,0.01,0.05})——表示将true转化为1，将false转化为0；SUM(N(D2>={0,0.01,0.05}))...

　　　46现在求求出三年五班女生的总余额。公式：=SUMPRODUCT((B2:B5="三年五")*(C2:C5="女"...