Hi
I'm trying to get the Sum totals for the 4 weeks from Cell BQ5 to BR5 into cell BK15 and then the Sum totals for the 5 weeks from Cell BS5 to BT5 into cell BM15 which is on the tab 'Revenue 2018-2019'
I can do the formula when the data is on the same tab (columns BD to BG), but how do I do it when the data is on a different tab?
Any help greatly appreciated.
Please use 2nd attachment as first is protected.
Regards
Paul
Do you mean that in BM15 on the Contract Change Sites tab (not the Revenue tab), you want the sum of cells AM4:AQ4 from the Revenue 2018-19 tab?
If so, you could use:
=SUM(INDEX('Revenue 2018-19'!4:4,MATCH($BS$5,'Revenue 2018-19'!$3:$3,0)):INDEX('Revenue 2018-19'!4:4,MATCH($BT$5,'Revenue 2018-19'!$3:$3,0)))
Hi Velouria,
Yes, formula works perfectly, I forgot INDEX as rarely use it.
Thank you so much for your help.
Regards
Paul
INDEX would also be more efficient than your current volatile INDIRECT and ADDRESS formulas. 😉
Thanks
Will try and update those formulas as well
Regards
Paul
