Quote Originally Posted by Glenn Kennedy View Post
omg.

Why do you think the SUMIF is incorrect. Its looking up the value in A1021 (5006-000177-5) and returning the correct value from cell OF37. I checked by cop/paste value the array in OD2:OF39 and changed the 1 to 11. The SUMIF worked OK.

So... WHY is it incorrect?
I see what you mean, OF37 is supposed to be A131 from "Input Page" which shown below as QTY: 12, it is somehow multiplying it by the number 2 rows down of 1792 on A133 of the "Input" sheet. I don't know why it would do that. So im guessing something is shifted over or something that is making it count the incorrect column.

Input page:
Attachment 811191