What Excel command functions like =INCLUDEIF() (if such a command existed)?
Posted on 2012-09-15
Is there a way to apply =MAX() to a single column range but only have it evaluate cells in the range which have a specific value in the adjacent column?
In other words, what function operates like =COUNTIF() or =SUMIF() but for something other than counting or summing — sort of like "=INCLUDEIF()" or in this specific case, "=MAXIF()."
For example, suppose all cells in A5:A1000 have a random integer value between 2005 & 2012. Is it possible to use =MAX(B5:B1000) but only have it evaluate those cells in B5:B1000 for which the value "2010" is present in the corresponding row in column A ?