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...