问题描述:
excel函数公式合并
如何将SUMPRODUCT(($B$2:$B$100=$D7)*($C$2:$C$100=7))与COUNTIF($A$2:$A$100,">="&F14)-COUNTIF($A$2:$A$100,">"&G14)两个公式合并?
如何将SUMPRODUCT(($B$2:$B$100=$D7)*($C$2:$C$100=7))与COUNTIF($A$2:$A$100,">="&F14)-COUNTIF($A$2:$A$100,">"&G14)两个公式合并?
问题解答:
我来补答展开全文阅读