Excel MAX IF Array Formula Tutorial - Free Microsoft Excel Spreadsheet Tips and Tutorials

By combining the MAX and the IF functions in an array formula in Excel, we can find the largest or maximum value for a range of data when a specific criterion is met. A step by step example is included on how to create a MAX IF array formula.

spreadsheets.about.com