Welcome To Ask or Share your Answers For Others

excel - Performing Sumifs on a closed WorkBook

asked Jan 31, 2022 in Technique[技术] by 深蓝 (71.8m points)

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?

See Question&Answers more detail:os

与恶龙缠斗过久,自身亦成为恶龙；凝视深渊过久,深渊将回以凝视…

165 views

Welcome To Ask or Share your Answers For Others

1 Answer

answered Jan 31, 2022 by 深蓝 (71.8m points)

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.

与恶龙缠斗过久,自身亦成为恶龙；凝视深渊过久,深渊将回以凝视…

...