Hello,
I have a range of data where I am pulling the actuals & budget for each period from another tab.
Highlighted cell formula
=SUMPRODUCT('Project Data Input'!$E$35:$BG$50,('Project Data Input'!$C$35:$C$50="Budget 23/24")*('Project Data Input'!$D$35:$D$50=$B87)*('Project Data Input'!$E$34:$BG$34=I$86))
Then below this I am calculating the YTD of the above
Highlighted cell formula
=SUM(OFFSET(I87,0,0,1,-MONTH(I$111)):I87)
What I want to do is just have one table where is is calculating the YTD calculations from the other tab I have - so would be a sumproduct using the offset but I am unsure how to do this.
Please can you show me how I could do this?
Thanks
Sarah
I have a range of data where I am pulling the actuals & budget for each period from another tab.
Highlighted cell formula
=SUMPRODUCT('Project Data Input'!$E$35:$BG$50,('Project Data Input'!$C$35:$C$50="Budget 23/24")*('Project Data Input'!$D$35:$D$50=$B87)*('Project Data Input'!$E$34:$BG$34=I$86))
Then below this I am calculating the YTD of the above
Highlighted cell formula
=SUM(OFFSET(I87,0,0,1,-MONTH(I$111)):I87)
What I want to do is just have one table where is is calculating the YTD calculations from the other tab I have - so would be a sumproduct using the offset but I am unsure how to do this.
Please can you show me how I could do this?
Thanks
Sarah