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.

Freezing a row in Microsoft Excel or Google Sheets can organize your spreadsheet and make sorting through data a breeze. Here's how to do it.

If you want to print an Excel spreadsheet but don't want to include rows that have a cell value of zero, you must filter the spreadsheet. Filtered rows will be skipped when you print your document.