Sumproduct - #value error

i am currently trying to use sum prouduct in the place of sumifs in a spreadsheet i am working on.I am trying to sum column E if column B contains any of the names in my named range and column a matches the month. However, i am getting a #value error and cannot figure out where i am going wrong. I have checked column E to make sure there is no text and unless it's a problem with my named range, i don't know what else could be causing the issue. Any help or feedback would be greatly appreciated as i am thoroughly stumped.


Column A = the month - in text format
Column B = Names
Column E= hours worked - formatted in numerical
Named Range - List of Names (names separated out by department)

Here is my formula
=sumproduct((B2:b66=Department)*(A2:a66="MAY")*(E2:E66))

Department is a named range that is a list of names that need to match the names in column B. Neither of the previous suggestions have worked.

department hours.xlsx

Attached is an example of my workbook. Thank you for your help