Forum Discussion

jrsilverio's avatar
jrsilverio
Copper Contributor
Apr 26, 2024

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 balance of the items.

 

=INDEX('[snd.xls]Sheet1'!$H:$H; CORRESP(A2; '[snd.xls]Sheet1'!$C:$C; 0))

 

Example: if there are two lines in which the reference is the same but the balance is different, the formula does not add the two balances and shows it in the cell

Formulas and Functions
Macros and VBA
  • AshaKantaSharma's avatar
    AshaKantaSharma
    Iron Contributor
    Aug 20, 2024
    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.

Resources