Sumproduct across multiple sheets using named range

Good morning all,

I have a simple sumproduct formula, that works against one sheet, however, i need it to also sum against multiple sheets within the same workbook using a named range. i have tried using indirect but to no avail.

can anyone help me,

thanks reg