Sumifs problem

Hello Dtripple40 

in A10

=SUMPRODUCT(
      (NUMBERS[[#Headers];[BENCH]:[PULL UPS]] = A8)
    * (NUMBERS[NAME] = A7)
    * NUMBERS[[BENCH]:[PULL UPS]]
)

If you only have 1 row of data per [NAME] in table NUMBERS the followings could do it as well

in A11

=INDEX(NUMBERS[[BENCH]:[PULL UPS]],
    MATCH(A7,NUMBERS[NAME],0),
    MATCH(A8,NUMBERS[[#Headers],[BENCH]:[PULL UPS]],0)
)

in A12 (Excel 365/Web only)

=FILTER(
    FILTER(NUMBERS, NUMBERS[NAME] = A7),
    NUMBERS[#Headers] = A8
)

Your updated file is attached

EDIT: To be complete. If Excel 365/Web and more than 1 row of data per [NAME] in table NUMBERS:

=SUM(
   FILTER(
      FILTER(NUMBERS, NUMBERS[NAME] = A7),
      NUMBERS[#Headers] = A8
   )
)