VLOOKUP SUM not getting correct values

I have a spreadsheet with VLOOKUP, SUM and arrays to get values from one spreadsheet to another. Problem is some values shows correctly but some doesn’t show or sometimes incorrect.

How can i create the behavior to consistent making all values correct. I have check all formulas and cells, seems all are correct.


Please provide a test kit which shows the problem (attach the files to the edited question).

Are you set the fourth argument of VLOOKUP (SortedRangeLookup) to 0 or FALSE()?