The function MAXIFs finds the largest value from a range of cells that meet an specific criteria from a separate range.
Syntax:
=MaxIfs(max range, criteria range 1, criteria 1, …)
Max range. Is the group of values or reference to a range of cell containing the values you want to find the largest value.
Criteria range 1. is the reference to a range of cell to be use to evaluate with the criteria.
Criteria 1. Is the criteria that defines which cells will be evaluated to find the largest value.
this function allows to add up to 126 criteria range/criteria pairs.