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.

There are a few ways to count the number of items in an Excel list, depending on the data you have. One way is using the COUNTIF function.

The sum function when filtering data is very important for Microsoft Excel users. This article will summarize for you how to filter and calculate sum in Excel using Subtotal.

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.

Sorting out a filtered list My students are great because they always pose questions on my courses. One that most commonly crops up is the one where they need to know if once they have filtered their ...

You can filter data in Excel based on either certain parameters in columns or over the whole sheet, and you can later unfilter the sheet.

Subtotals - Having a list in Excel and just filtering it does not always give you all you desire. Using the Subtotal function in that list may.

Excel tables have many benefits that regular spreadsheets lack. The biggest is the option to use data from multiple tables to create queries and reports.

Deleting rows from a large filtered range in Microsoft Excel can take a long time, temporarily place the program into a "not responding" state, or—in a worst-case scenario—cause Excel to crash ...