Dynamic named ranges are not woking with SUMIFS function

Hello Excel Forum:
My problem is that when I used dynamic named ranges with SUMIFS, I get a #Value! error.
The SUMIFS works when I use traditional cell references (B15: B26) style. The dynamic named ranges also work for SUM and AVERAGE on the same sheet. So I feel that the dynamic name ranges are correct. When I substitute the named ranges (Dy_Hrs) or (Dy_Fuel) in the SUMIFS function in place of the cell references, I get the error. Once I am convinced that the Dynamic ranges and the SUMIFS work, I want to move to VBA Code. See attached Workbook.

I am using SUMIFS to add the hours in Range (B15:B26), dynamic range but EXCLUDING the work categories of Contractor, Support, Stripping.

Any help would be appreciated

Knightflier

Hello TMS: Still get the error #value! What I do not understand is the Sum, and Average functions work fine on the same sheet using the same dynamic ranges. When I use the SUMIFS function with normal cell references

=SUMIFS(B15:B26,D15:D26,"<>" &"Contractor",D15:D26,"<>" &"Stripping",D15:D26,"<>" &"Support",D15:D26,"<>"&"Contractor-Stripping")

all works as is should. When I substitute a dynamic range name "dy_Hrs" for the B15: B26 range, I get the error #VALUE!