Hi everyone!
Please help!
In this FILE, in the sheet "Report", cell R8, I have to sum the amounts from one row (8) in 2 sheets ("Expenses Berlin" and "Expenses Novi Sad").
This should be from Jan 2019 (cell N4) to Mar 2019 (cell O4) (both in different cells so it can be changed - so it has YTD overview), provided that Planned (cell R4) matches Planned (row 4 in the other 2 sheets I mentioned). The dates in the other 2 sheets are in one row (3).
I made this formula:
=SUM(INDEX('Expenses Berlin'!G8:AP8, MATCH(N4 & R4,'Expenses Berlin'!G3:AP3 & 'Expenses Berlin'!G4:AP4, 0)):INDEX('Expenses Berlin'!G8:AP8, MATCH(O4 & R4,'Expenses Berlin'!G3:AP3 & 'Expenses Berlin'!G4:AP4, 0)))+SUM(INDEX('Expenses Novi Sad'!G8:AP8, MATCH(N4 & R4,'Expenses Novi Sad'!G3:AP3 & 'Expenses Novi Sad'!G4:AP4, 0)):INDEX('Expenses Novi Sad'!G8:AP8, MATCH(O4 & R4,'Expenses Novi Sad'!G3:AP3 & 'Expenses Novi Sad'!G4:AP4, 0)))
But even though is giving me some values, it doesn't give the correct ones.
Do you have any ideas how this formula should look like to give me the correct values?
Thank you very much!
Please help!
In this FILE, in the sheet "Report", cell R8, I have to sum the amounts from one row (8) in 2 sheets ("Expenses Berlin" and "Expenses Novi Sad").
This should be from Jan 2019 (cell N4) to Mar 2019 (cell O4) (both in different cells so it can be changed - so it has YTD overview), provided that Planned (cell R4) matches Planned (row 4 in the other 2 sheets I mentioned). The dates in the other 2 sheets are in one row (3).
I made this formula:
=SUM(INDEX('Expenses Berlin'!G8:AP8, MATCH(N4 & R4,'Expenses Berlin'!G3:AP3 & 'Expenses Berlin'!G4:AP4, 0)):INDEX('Expenses Berlin'!G8:AP8, MATCH(O4 & R4,'Expenses Berlin'!G3:AP3 & 'Expenses Berlin'!G4:AP4, 0)))+SUM(INDEX('Expenses Novi Sad'!G8:AP8, MATCH(N4 & R4,'Expenses Novi Sad'!G3:AP3 & 'Expenses Novi Sad'!G4:AP4, 0)):INDEX('Expenses Novi Sad'!G8:AP8, MATCH(O4 & R4,'Expenses Novi Sad'!G3:AP3 & 'Expenses Novi Sad'!G4:AP4, 0)))
But even though is giving me some values, it doesn't give the correct ones.
Do you have any ideas how this formula should look like to give me the correct values?
Thank you very much!