You can't use a SUM() function to sum a filtered list, unless you intend to evaluate hidden and unhidden values. Here's how to sum only the values that meet your filter's criteria.

Learn how to use Excel FILTER, XLOOKUP, and SUMIFS functions to streamline workflows and make smarter data-driven decisions.

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