Excel Forum
Similar Content
Filter Data Sets on Multiple Columns with Multiple Criteria at Once in Excel - AutoFilter
Macro: This Excel macro allows you to filter a data set on multiple columns and criteria at once....
Group Data Together for Increased Readability in Excel
Tutorial: How to group data together or collapse it in order to focus only on the important data in...
Round Numbers Up or Down in Excel
Tutorial: How to round a number up or down and also to a specified number of decimal places in Excel...



Excel Magic Trick #507: Fix Bad Data So We Can Add With Two Criteria & Make Summary Report


See how to take badly setup data (not in database / table format) and summarize it by date and shipping name into table format report. See these tricks to fix bad data so we can Add with Two Criteria:
1.Advanced Filter Unique Records Only
2.Go To Special Blanks
3.Create Formula to add missing dates to a column of dates so that the Summary Formula will work
4.See how to enter multiple formulas with one keyboard shortcut (Ctrl + Enter)
5.SUMPRODUCT function to add with two criteria
6.Learn about TRUE FALSE Boolean Math Logic





Got a Question? Ask it Here in the Forum.