MAXIFS

Returns largest value matching conditions.

Excel: Not checked yet
Google Sheets: Not checked yet
Returns: Number

Examples

=MAXIFS(B1:B3, A1:A3, ">15")

	A	B
1	10	2
2	20	4
3	30	6

Result 6

Syntax

MAXIFS(max_range, criteria_range1, criteria1, [criteria_range2…], [criteria2…])

max_range: range required
criteria_range1: range required
criteria1: any required
criteria_range2…: range optional
criteria2…: any optional

AVEDEVAverage of absolute deviations from the mean. AVERAGE.WEIGHTEDAverage of values weighted by a second range. AVERAGEAAverages values including text and logicals. AVERAGEIFAverages cells that match a condition. AVERAGEIFSAverages cells matching multiple conditions. BETA.DISTBeta distribution.