Forum Discussion

Annlee107's avatar
Annlee107
Copper Contributor
Oct 13, 2020
Solved

Entering a sumif formula over multiple sheets

I am attempting to enter a sumif formula over multiple tabs by highlighting the tabs required. I have a seperate tabs for each week of the year and another containing the sales data. All of the crite...
  • HansVogelaar's avatar
    Oct 13, 2020

    Annlee107 

    Use

    =SUMIF('Sales Data'!B1:BL1,H4,'Sales Data'!B35:BL35)

Resources