Main Profile

At A Glance

Mr Excel & excelisfun Trick 52: Lookup Two Criteria: SUMIFS, DGET, or Array Formula?

See Mr Excel and excelisfun lookup a value given two criteria. You will see three formulas: SUMIFS formula, DGET formula, and an array formula that uses MATCH & INDEX functions and concatenated (joined) cells and ranges. See how to use the INDEX function to turn a Ctrl + Shift + Enter array formula into just an Enter array formula. Avoid Ctrl + Shift + Enter by using the INDEX function and a blank as the row argument.
Length: 08:45

Contact

Questions about Mr Excel & excelisfun Trick 52: Lookup Two Criteria: SUMIFS, DGET, or Array Formula?

Want more info about Mr Excel & excelisfun Trick 52: Lookup Two Criteria: SUMIFS, DGET, or Array Formula?? Get free advice from education experts and Noodle community members.

  • Answer

Ask a New Question