Jan 29 2019 05:38 AM
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
Jan 29 2019 07:37 AM
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.
Jan 29 2019 07:39 AM