You’ll find it under the Formulas tab, in the Formula Auditing group. Once you open it, just hit Add Watch and select the cells you want to monitor. The pop-up will show you the sheet name, cell ...

SUM is the spreadsheet equivalent of an open invite: it welcomes everything into the total, whether it belongs there or not.