<div>
Hi Barry, i think the second solution is what i am after. &nbsp;Thank you for the note ant sumifs. &nbsp;I assume the same applies with vlookup.<br />
<br />
Couldnt i auto open the data file upon open of source file?
</div>


<div>
that is tricky. &nbsp;thank you. &nbsp;It works fine. &nbsp;I have tested it.
</div>


<div>
<div class="content wysiwyg-content">
Experts, <br />
<br />
How would I modify the below to add another condition of like *DnB*?<br />
<br />
=SUMIFS([test_delete.xlsx]<wbr />Sheet1!$K$<wbr />2:$K$472,[<wbr />test_delet<wbr />e.xlsx]She<wbr />et1!$G$2:$<wbr />G$472,&quot;*Sa<wbr />ntander*&quot;,<wbr />[test_dele<wbr />te.xlsx]Sh<wbr />eet1!$U$2:<wbr />$U$472,&quot;GI<wbr />S&quot;)<br />
<br />
thank you
</div>
</div>


Experts, 

How would I modify the below to add another condition of like *DnB*?

=SUMIFS([test_delete.xlsx]Sheet1!$K$2:$K$472,[test_delete.xlsx]Sheet1!$G$2:$G$472,"*Santander*",[test_delete.xlsx]Sheet1!$U$2:$U$472,"GIS")

thank you

Hi Barry, i think the second solution is what i am after.  Thank you for the note ant sumifs.  I assume the same applies with vlookup.

Couldnt i auto open the data file upon open of source file?

that is tricky.  thank you.  It works fine.  I have tested it.

SUMIFS

Experts, 

How would I modify the below to add another condition of like *DnB*?

=SUMIFS([test_delete.xlsx]Sheet1!$K$2:$K$472,[test_delete.xlsx]Sheet1!$G$2:$G$472,&quot;*Santander*&quot;,[test_delete.xlsx]Sheet1!$U$2:$U$472,&quot;GIS&quot;)

thank you

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.