colinheslop1984
Board Regular
- Joined
- Oct 14, 2016
- Messages
- 129
- Office Version
- 2016
Is there a way for a sumif to work when one of the criteria is a tab?
I want to build a sheet that will contain a drop down menu of week numbers which will be named exactly after each tab label and to use this cell as the reference criteria for the sumif.
Hopefully that makes sense. Can this be done and how?
Basically want cell c2 to show me the value of h12 of one of the sheets if the name of that tab is diplayed in a1.
If not possible, what would be an alternative?
I want to build a sheet that will contain a drop down menu of week numbers which will be named exactly after each tab label and to use this cell as the reference criteria for the sumif.
Hopefully that makes sense. Can this be done and how?
Basically want cell c2 to show me the value of h12 of one of the sheets if the name of that tab is diplayed in a1.
If not possible, what would be an alternative?