^ you could likely make the formula an indirect reference and then copy the formula down to work with each individual file.
if you do it this way and someone moves the files your formulas will no longer work
__________________
If I do not come back avenge my death
|