Forum Discussion
Automate way of pulling information without having to leave 2 files open
=SOMASE([almox.xls]Sheet1!$C:$C;A2;[almox.xls]Sheet1!$H:$H) I converted my formula to this one, as it pulls information without having to open the file, but it is not correctly adding up the bala...
To sum values based on criteria from a closed workbook without keeping both files open, use the SUMIFS function with the correct file path. Ensure the file path is accurate, and consider using named ranges or Power Query for more dynamic and complex scenarios.