Highlighted
New Contributor

# MINIFS Function

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 Replies
Highlighted

# Re: MINIFS Function

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.

# Re: MINIFS Function

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