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...
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.