Log In
Register
Home
July 11, 2017
Offline
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
Trusted Members
Moderators
November 1, 2018
Online
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)))
July 11, 2017
Offline
Hi Velouria,
Yes, formula works perfectly, I forgot INDEX as rarely use it.
Thank you so much for your help.
Regards
Paul
1 Guest(s)
