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

Excel’s BYCOL() and BYROW() functions evaluate data across columns and rows, returning an array result set allowing you to bypass a lot of work.