Linking sumif from external database file

[George]

Hi,
I have multiple excel files that used range name and data validation,
is there a way to link Sumif or Lookup with external database file and data
validation.

 

[George]

Most likeli I should say, can I import from database file into formula