Forum Discussion
VALUE Error When Combining IF with SUMPRODUCT
Hi,
Please I need assistance with IF and SUMPRODUCT formula that keeps returning a Value Error.
I want to return sales value that match 4 criteria: the customer selected in Column C2, Product ID in E8 and between two dates columns F8 and G8.
However, as shown in photo 1, while the formula returns the correct numbers for Customer B (which table is in the same workbook i'm using), it returns a Value Error when I link to an external workbook as shown in photo below:
2 Replies
Break down the formula and evaluate parts of it to identify where the error arises. For example, you could enter just the customer criteria in a separate cell to check whether it returns a valid range.
If you're dealing with dynamic ranges, ensure that the named ranges (if you’re using them) or the ranges themselves are correct and do not contain errors.
