Excel Forum
Similar Content
Sum Values that Equal 1 of Many Conditions across Multiple Columns in Excel
Tutorial: How to Sum values using an OR condition across multiple columns, including using OR with ...
Vlookup on Dates and Times in Excel
Tutorial: Perform a lookup on dates and times in Excel: vlookup, hlookup, index/match, any kind of l...
Convert an Incorrect Date Format into a Real Date in Excel
Tutorial: Change an incorrectly formatted/input date into the proper date format for Excel. This tut...



Excel Magic Trick 757.5: Two Lookup Columns Or Sum With Two Criteria?


Download file: https://people.highline.edu/mgirvin/ExcelIsFun.htm
Learn about the difference between looking up a value when there are two lookup values and adding values when there are two criteria. See the functions INDEX, MATCH, SUMPRODUCT and SUMIFS
This video is in response to:
Excel Magic Trick 757: Two Lookup Values and Two Lookup Columns? Great Formula INDEX & MATCH





Got a Question? Ask it Here in the Forum.