Indirect + Sum Function not working when referencing another sheet

Hi,

I have a combination of Sum and Indirect Formula where I want to Reference to another sheet via the sum function and the reference (indirect) function.

My problem is that when I do these calculations exactly the same on the same sheet I can do them without problem. When I split the data up and add the Sheet name in the sum it stops working

Please Login or Register  to view this content.

Please Login or Register  to view this content.

I need to do it this way because in my project there is the data range on another sheet and the calculations on a seperate sheet. The "Helper column" is there because in my project I search for this specific Adress through index and match function and did not want my sum cell to be filled with too much formula stuff.


If VBA is more efficient for this Task let me know. But it seems so easy though it just wont work

best decar

Indirect + Sum.xlsx

Thank you!!!


I really envy your excel skills








I could not think of a solution because it worked when I simply put in the value of Indirect(d15) so I thought it has to go without the sheet reference an Indirect as well.