If your company is working with a large list in an Excel spreadsheet, take advantage of the program's built-in filter customization tools to limit the number of rows included in your filter results.

How to Include All Rows for Filters in Excel. Microsoft Excel helps you sort your data for analysis by providing a Filter command. For example, when you want to sort number values from low to high ...

Learn how to filter data using wild cards and other complex criteria using Advanced Filter in Excel.

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