SUMPRODUCT using dynamic name range as lookup criteria (name range has multiple values)

Hello,

I have the following SUMPRODUCT formula and it's working

Please Login or Register  to view this content.

However, when I make $B$3:$E$3 as name range, the formula didn't work.

I tried ways, such as putting double quotation and took out the 'TEXT' function completely and didn't work.

May I know what did I do wrong? Or SUMPRODUCT can't use name range as a multiple lookup?

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please note that I'm trying to avoid using SUM and SUMIF array ( I know it works). The reason I'm avoiding it is because, it's taking a very long time to calculate. Whereas SUMPRODUCT is almost instant

SUMPRODUCT does not work with 2 dimential ranges
use SUm as an arrayformula