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?
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:
Is there a MAXIFS equivalent? 


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 

