Dueling Excel 52


Lookup Two Criteria: SUMIFS, DGET, or Array Formula?

DESCRIPTION

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.

WORKBOOKS




Be the first to comment

Leave a Reply