How to find the largest value from a range by a criterion?

Question

Google Sheets

I need to get the maximum value (number) from one array, provided that the data lines from another array are text (I can explain badly). I give an example of use with a basic function:

=СУММЕСЛИ('List 1'!B:B; "Иван Иванов"; 'List 1'!P:P)

So I got the amount, provided that in another column we take into account data from rows with the value "Ivan Ivanov". How to use this to calculate the maximum value?

PS Why? I want to display the maximum check for managers from unloading.

Answer 1

Most likely it is
=MAXIFS('List 1'!P:P,'List 1'!B:B,"Ivan Ivanov")

Example in Spreadsheet https://docs.google.com/spreadsheets/d/1VQIqpPhg87...