2. You can’t use the SUMIFS function across multiple sheets…well not on its own. Solution 1: The slow option If you’ve got oodles of time and a super computer you could add one SUMIF to another in one massive long formula like this: =SUMIF(Jan!$A$3:$A$8,Summary!A5,Jan!B3:...