1. Computing
Ted French

Excel MAX IF Array Formula

By December 29, 2012

Follow me on:

Excel MAX IF Array Formula
Excel MAX IF Array Formula
Ted French

The MAX function will find the largest value in a given list of data.

The IF function lets you set conditions so that you can control what data is used by a formula.

An array formula lets you carry out multiple calculations in a single cell.

Put them all together and you have a single formula that will test one range of data to see it meets the set condition, and, if it does, the formula will find the largest value in a second range.

To find out all the details, read this tutorial on the Excel MAX IF Array Formula.

Related Tutorials

Comments
April 18, 2013 at 11:12 am
(1) Michael says:

This formula is awesome. I am now able to do some really cool agile tracking calculations that was impossible before. Thank you

February 10, 2014 at 11:59 am
(2) Adam says:

Amazing, thanks for sharing!

February 11, 2014 at 11:34 am
(3) Rafael says:

Thanks now i could create variants of this formula

Leave a Comment

Line and paragraph breaks are automatic. Some HTML allowed: <a href="" title="">, <b>, <i>, <strike>

©2014 About.com. All rights reserved.