I have the following formula at the moment, where 22May UoE Weight Data ECC.xlsx]Card (Clean) is the filename of another workbook and worksheet.
=SUMIF('[22May UoE Weight Data ECC.xlsx]Card (Clean)'!$N:$N,A3,'[22May UoE Weight Data ECC.xlsx]Card (Clean)'!$E:$E)
I would like to be able to put the filename in another cell, then reference that cell in the formula. That way, I'll be able to change the name of the file in that cell to reference another workbook to update my tables.
Any ideas?