Use the MAXIFS and MINIFS Functions

preview_player
Показать описание
If you've got Excel 2016, you've got the MINIFS and MAXIFS functions. They let you find the minimum (lowest) and maximum (highest) values based on one or more conditions (criteria). The criteria can be numeric or text and this video will show you how.

📝 This description may contain affiliate links and we'll receive a small commission if a purchased is made using the links (but at no additional cost to you). It'll support the channel and so more videos like this can be made. Thanks for your support!

#excel
#msexcel
#doughexcel
Рекомендации по теме
Комментарии
Автор

Such great functions! Thanks, Doug H : ) But why the column references rather than range?

excelisfun