81% OFF online library of tutorials for mastering Google Sheets

One time purchase $199



Returns the maximum value in a range of cells, filtered by a set of criteria..

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.