SUMPRODUCT referencing a Spill from a named range

Hi there

I'm building a forecast template for a customer. In a matrix with dated columns, they create and name a bunch of rows; give each a General Ledger number (representing the account in their accounting system) and record person days against them. On another sheet they repeat those same rows twice: once for income and once for costs. Against these two sections they record a unit price/cost and then calculate a monthly total for each line based on the person days from the first sheet and the unit price/cost against the equivalent rows on the second sheet.

A third sheet then reads from the Income/Cost sheet using SUMPRODUCT to bring back the total for each General ledger Account. This works fine.

However...in order to make it dynamic and to prevent them having to copy the list of row names and account numbers, I created these as a Named Range on the first sheet and then referenced it on the Income and cost sections of the second sheet, allowing the result to spill. This worked well but caused the SUMPRODUCT to cease working (it's now filled with zeros). 

I've tried using the # to reference the named range in the SUYMPRODUCT formula but to no avail. 

Any help or hints would be appreciated.