HOW TO LOCK FORMULA SOMASE AND UPDATE IT BY ITSELF?

I made a SOMASE formula to pull data from 2 spreadsheets, the problem is that I always need to replace the files with current ones with new information, and the SOMASE formula in the base spreadsheet...