问题描述:
您好!能麻烦您给详细解析公式=SUMPRODUCT(N(EXACT(B2:B10,"A")))每一步的计算值,
EXACT(B2:B10,"A")))返回返回逻辑值TRUE;
N(EXACT(B2:B10,"A"))将TRUE转换为数值1;
SUMPRODUCT(N(EXACT(B2:B10,"A")))则我弄不明白是如何计算出来的?
EXACT(B2:B10,"A")))返回返回逻辑值TRUE;
N(EXACT(B2:B10,"A"))将TRUE转换为数值1;
SUMPRODUCT(N(EXACT(B2:B10,"A")))则我弄不明白是如何计算出来的?
问题解答:
我来补答展开全文阅读