SUMIFS producing #VALUE!

Offtop
XOR LX, XLent could you test vlookup function also. I have info about catastrophic dependency from range in the new version of Excel. Unfortunately there is article in Russian but
Способ 1. ВПР is VLOOKUP(B2,$G$2:$H$600,2,0) 4,3 s
Способ 2. ВПР с выделением столбцов целиком VLOOKUP(B2,$G:$H,2,0) -14,5 s

Dear moderator if it is not possible to discuss here sorry. I agree with XLent it could be new thread.