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.

If your Excel lists repeats values and you need help finding changes, try this easy conditional format. One of the most frequent requests I receive from readers is how to highlight list values ...

If you wish to count the same or duplicate values in a column only once in Excel or the count of occurances of duplicate values, read this article.

Tips Verify that your operation worked by clicking one of the new cells. You see the same drop-down list open and display its values. Click one of the values and Excel will use it to populate the ...

How to Isolate a Value in Excel. Isolating values in an Excel 2007/2010 worksheet or workbook is common in both error-checking and data analysis tasks. While appropriate even for a small worksheet ...

Suppose you are a project manager using Excel to track your team’s tasks. You have created a database with columns like Tasks, Assignee, Status, and Due Date. Now you want to ch ...

How to create an automated list of worksheet names in Excel -- and add a table of contents.

Learn how to count the number of unique and distinct values in a column based on data in another column using array in Microsof Excel.