|
|
=ROUND(SUM(SUMIFS(贷款余额表!CC:CC,贷款余额表!AU:AU,{"13010201","13010301","13040101"},贷款余额表!AV:AV,{"*次级*","*可疑*","*损失*"},贷款余额表!S:S,"*信用*"))/10000,2)大佬们，这个公式怎么改进？
贷款余额表!AU:AU,{"13010201","13010301","13040101"},是从科目分类中选出这三个科目
贷款余额表!AV:AV,{"*次级*","*可疑*","*损失*"}，是从五级分类中选出这三类
计算出来的数值比手工筛选的实际金额小。 |
|
