Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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
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:


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:… – Rhys Gibson Sep 12 '12 at 0:04

Your Answer


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.