excel - Performing Sumifs on a closed WorkBook

Question

I want to create a Function routine in WorkBook1 that performs the Sumifs calculation on a closed WorkBook2. Does anyone know of any simple code?

Answer 1

SUMIF function will not work with closed workbooks.

A workaround is to use a worksheet with direct references to each significant cell in the closed workbooks and do your SUMIF on this worksheet.