Just found out similar questions have been answerd earlier. The Sumif
does not work on closed workbooks, only Sumproduct. Will spend a bit
more time seaching the groups before posting next time :)