Leviatano80
New Member
- Joined
- Nov 22, 2022
- Messages
- 3
- Office Version
- 365
- Platform
- Windows
Hi, I hope that you can help with this.
I use Indirect function to calculate sum if I mees specific conditions. =SUMPRODUCT(SUMIFS(INDIRECT("'"&$Y$1:$Y$34&"'!j2:j103");INDIRECT("'"&$Y$1:$Y$34&"'!e2:e103");'Global Forecast'!$E2))
using F9 and selecting only this part of formula SUMIFS(INDIRECT("'"&$Y$1:$Y$34&"'!j2:j103");INDIRECT("'"&$Y$1:$Y$34&"'!e2:e103");'Global Forecast'!$E2) I am able to see all the elements of my matrix {0;0;0;0;0;0;0;22;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0} but for me it would be more useful to see the name of the TAB so that I can understand from which tab we have a value. in this case I should check that value 22 comes from tab 8.
any solution?
thank you
I use Indirect function to calculate sum if I mees specific conditions. =SUMPRODUCT(SUMIFS(INDIRECT("'"&$Y$1:$Y$34&"'!j2:j103");INDIRECT("'"&$Y$1:$Y$34&"'!e2:e103");'Global Forecast'!$E2))
|
any solution?
thank you