TatsuSheva
New Member
- Joined
- Apr 30, 2018
- Messages
- 1
[FONT="]Hello, I am trying to sum values from the sheet which it's name is J1 to the actual sheet.[/FONT]
[FONT="]Here is what I did: [/FONT]
[FONT="]How can I combine both in order to get my values ?[/FONT]
[FONT="]EDIT: [/FONT]
[FONT="]I find out something but I get the result as #REF ! here is the formula [/FONT]
[FONT="]=SUM(indirect("'J1:"&MID(CELL("filename",A3),FIND("]",CELL("filename",A3))+1,256)&"'!O1187"))[/FONT]
[FONT="]Do you have any idea how to fix this ? [/FONT]
[FONT="]Here is what I did: [/FONT]
- The Sum : =SUM('J1:Here I have to put the actual sheet'!O1187)
- Find the actual sheet: =MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,256)
[FONT="]How can I combine both in order to get my values ?[/FONT]
[FONT="]EDIT: [/FONT]
[FONT="]I find out something but I get the result as #REF ! here is the formula [/FONT]
[FONT="]=SUM(indirect("'J1:"&MID(CELL("filename",A3),FIND("]",CELL("filename",A3))+1,256)&"'!O1187"))[/FONT]
[FONT="]Do you have any idea how to fix this ? [/FONT]