conditional sum across worksheet pages

I do like the idea of a terror message!!

So, you were nearly there. The Named Range (SheetList) can be viewed by using CTRL F3. As for the rest, you used the wrong sort of tick (how naughty of you!! ). It needs to be ' and not `. Also there was the odd ampersand missing.