Hi all -
I have sumproduct formula that returns #N/A error and I'm not sure why
If I narrow the range from $939 to $1093 then the formula works.
But that is only evaluating 1 unit of 10
As I add worksheets to the workbook and update the unit numbers in B10, the entire range needs to be evaluated for matching criteria.
Sorry, workbook is way too large to upload.