I don’t know how you can do it across multiple files but on multiple “sheets” it would be something like
=SUM(E8:L8,Sheet2!D4:M4,Sheet3!E6:N6)
I don’t know how you can do it across multiple files but on multiple “sheets” it would be something like
=SUM(E8:L8,Sheet2!D4:M4,Sheet3!E6:N6)