Table of Contents
MAXIFS is a function in Google Sheets that allows users to find the maximum value in a range based on specified criteria. This can be useful when working with large sets of data and wanting to find the highest value that meets certain conditions. To use MAXIFS, the user must specify the range to search, followed by the criteria range and the corresponding criteria. Multiple criteria can be used to further refine the search. For example, the formula =MAXIFS(A2:A10, B2:B10, “>100”, C2:C10, “>=50”) will find the highest value in column A that is greater than 100 and corresponds to a value of 50 or higher in column C. This allows for efficient and precise data analysis in Google Sheets.
Use MAXIFS in Google Sheets (With Examples)
You can use the MAXIFS function in Google Sheets to find the max value in a range, filtered by a set of criteria.
This function uses the following basic syntax:
=MAXIFS(range, criteria_range1, criteria1, [criteria_range2, criteria2, …])
The following examples show how to use this syntax in practice.
Related:
Example 1: Use MAXIFS with One Criterion
Suppose we have the following dataset that shows the points scored by 15 different basketball players:
We can use the following formula to calculate the max points scored IF the player is on team A:
=MAXIFS(C2:C16, A2:A16,"A")
The following screenshot shows how to use this formula in practice:
We can see that the max points value among players on team A is 35.
Example 2: Use MAXIFS with Multiple Criteria
Suppose we have the same dataset that shows the points scored by 15 different basketball players:
We can use the following formula to calculate the max points scored IF the player is on team A andIF the player has a Guard position:
=MAXIFS(C2:C16, A2:A16,"A", B2:B16, "Guard")
The following screenshot shows how to use this formula in practice:
We can see that the max points value among players who are on team A and have a Guard position is 30.
Note: In these examples we used the MAXIFS() function with one criterion and two criterion, but you can use the same syntax to use as many criterion as you’d like.
Additional Resources
Cite this article
stats writer (2024). How do I use MAXIFS in Google Sheets with examples?. PSYCHOLOGICAL SCALES. Retrieved from https://scales.arabpsychology.com/stats/how-do-i-use-maxifs-in-google-sheets-with-examples/
stats writer. "How do I use MAXIFS in Google Sheets with examples?." PSYCHOLOGICAL SCALES, 1 Jul. 2024, https://scales.arabpsychology.com/stats/how-do-i-use-maxifs-in-google-sheets-with-examples/.
stats writer. "How do I use MAXIFS in Google Sheets with examples?." PSYCHOLOGICAL SCALES, 2024. https://scales.arabpsychology.com/stats/how-do-i-use-maxifs-in-google-sheets-with-examples/.
stats writer (2024) 'How do I use MAXIFS in Google Sheets with examples?', PSYCHOLOGICAL SCALES. Available at: https://scales.arabpsychology.com/stats/how-do-i-use-maxifs-in-google-sheets-with-examples/.
[1] stats writer, "How do I use MAXIFS in Google Sheets with examples?," PSYCHOLOGICAL SCALES, vol. X, no. Y, ص Z-Z, July, 2024.
stats writer. How do I use MAXIFS in Google Sheets with examples?. PSYCHOLOGICAL SCALES. 2024;vol(issue):pages.