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:

​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:   Read More

​