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))