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 VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course




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.