Max Value based off criteria

Microsoft Excel 2003 (full product)
July 26, 2010 at 12:15:43
Specs: Windows XP
I need to get the max number of days that an item has been open based off specific criteria.
For Example:
The data that is collected is for countries, status, and number of days open.
I need the equation to check that all the rows with Brazil and unresolved which one has the largest number in the days open column. The spreadsheet has many countries listed so it will need to check the first 2 variables then compare them to find the max number of days. Thanks in advance on this one.

See More: Max Value based off criteria

Report •

July 26, 2010 at 12:49:26
One way is with this Array Formula:


Enter this formula with Ctrl-Shift-Enter to place the {} around it and make it an array formula.

Report •

July 26, 2010 at 13:25:58


SUMPRODUCT works like an array formula but does not need the Ctrl-Shift-Enter and Curly braces.


Report •

Related Solutions

Ask Question