Hello, I am trying to sum values from the first sheet to the actual sheet.
Here is what I did:
The Sum : =SUM('Sheet1:Here I have to put the actual sheet'!O1187)
Find the actual sheet: =MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,256)
How can I combine both in order to get my values ?