Returns the maximum value in a range of cells, filtered by a set of criteria..
81% OFF online library of tutorials for mastering Google Sheets
MAXIFS()
Description
How To Use in Sheets
MAXIFS(range, criteria_range1, criterion1, [criteria_range2, criterion2], …)
External Links
Google Sheets Tutorial for Sports Science: Unlock the Power of MAXIFS
This is a video designed for sports scientists, sport and strength coaches, and other practitioners working in sport on how to get the most out of Google Sheets for sports science and performance. We learn how to use the function MAXIFS in a variety of real-world scenarios in the sports science world. You've probably never used MAXIFS 3 times in the same formula before, but after this video, you will see when and why you should!
0Better Sheets Tutorials
No videos featuring this formula, yet. Stay tuned! In the mean time check out blogs below, and more formulas here at Better Sheets.