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 ?
EDIT:
I find out something but I get the result as #REF! here is the formula
=SUM(indirect("'Sheet1:"&MID(CELL("filename",A3),FIND("]",CELL("filename",A3))+1,256)&"'!O1187"))
Do you have any idea how to fix this ?