=SUMPRODUCT((F4:F500=J7)*(B4:B500=K7)*D4:D500)
改为
=SUMPRODUCT((F4:F500=J7)*(B4:B500=K7)*N(D4:D500))
----------------------
=SUMPRODUCT((F4:F500=J7)*(B4:B500=K7)*D4:D500)
被计算的数字是通过=IF(C4="单笔",20,IF(C4="额度",20,IF(C4="额度+单笔",40,IF(C4="保证",30,IF(C4="否决",10,"未输入")))))计算出来的,现在想通过=SUMPRODUCT((F4:F500=J7)*(B4:B500=K7)*D4:D500)再计算上面公式计算出来的数据就报错
追问看不太懂,这个公式是填在第二个图片的J5里吗?