Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I have a table of data that I want to find a MAX value for.

The challenge is filtering the values I care about.

Basically, I want the MAX from Column D when:

  • Column A = 'VIC'
  • Column B = 'CBD'
  • Column C = 'Leaderboard'

Is there a MAXIFS equivalent?

share|improve this question
add comment

1 Answer

up vote 2 down vote accepted

There's no built in function for this, but you can achieve what you want with an array formula.

You enter it as:

=MAX(IF(A1:A20="VIC",IF(B1:B20="CBD",IF(C1:C20="Leaderboard",D1:D20))))

and then commit it using CTRL+SHIFT+ENTER rather than just ENTER. This will add {} around the formula and turn it into an array formula

share|improve this answer
    
you da man! I've never used teh {} before - how does it change the statement? –  php-b-grader Sep 11 '12 at 23:54
    
Basically, it turns it into what you wanted. They take a bit of getting your head around - see here for a starter: office.microsoft.com/en-us/excel-help/… –  Rhys Gibson Sep 12 '12 at 0:04
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.