MINIFS Function

[Mail2Subrahmanyam]

Can anyone explain the example 6 which is mentioned in the below link 

https://support.office.com/en-us/article/minifs-function-6ca1ddaa-079b-4e74-80cc-72eef32e6599

[#2]

Last row on screenshot is #7 (400 is in D7), and the range is D2:D6. Row 1 is for titles ("Level" is in D1).

On the other hand have no idea why they included that last row.

[#3]

If you look closely you'll see that the last row of the table is NOT included in the MINIFS formula.