1

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?

2

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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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