rsd007
New Member
- Joined
- Oct 24, 2022
- Messages
- 27
- Office Version
- 2019
- Platform
- Windows
Hello,
I am using Sumproduct with multiple criteria in various cell but if the criteria is false and the value which will be multiplying is blank I get #VALUE error after that.
=IF(OR(D9=$P$1:$P$3),SUMPRODUCT((N(+$H$8:H9))*(ABS($J$8:J9))*($E$8:E9=E9)*(ISNUMBER(MATCH($D$8:D9,$P$1:$P$3,0)))),"")
Thanks
I am using Sumproduct with multiple criteria in various cell but if the criteria is false and the value which will be multiplying is blank I get #VALUE error after that.
=IF(OR(D9=$P$1:$P$3),SUMPRODUCT((N(+$H$8:H9))*(ABS($J$8:J9))*($E$8:E9=E9)*(ISNUMBER(MATCH($D$8:D9,$P$1:$P$3,0)))),"")
Thanks