# Summing Values from Different Sheets for the Same Cell Address (EXCEL)

Page 1 of 1

## 0 Replies - 1419 Views - Last Post: 29 April 2018 - 02:05 PM

### #1 SniperCode

Reputation: 0
• Posts: 37
• Joined: 06-September 16

# Summing Values from Different Sheets for the Same Cell Address (EXCEL)

Posted 29 April 2018 - 02:05 PM

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 ?

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 ?

Is This A Good Question/Topic? 0

Page 1 of 1

 .related ul { list-style-type: circle; font-size: 12px; font-weight: bold; } .related li { margin-bottom: 5px; background-position: left 7px !important; margin-left: -35px; } .related h2 { font-size: 18px; font-weight: bold; } .related a { color: blue; }