## 'MAXIFS function' category

How to use the MAXIFS function

The MAXIFS function returns the largest number based on a condition or criteria. The MAXIFS function was introduced in Excel […]

The MAXIFS function returns the largest number based on a condition or criteria. The MAXIFS function was introduced in Excel […]

Find and return the highest number and corresponding date based on a condition

This article describes how to filter records based on the maximum value of a specific item. There are names in […]

This article describes how to filter records based on the maximum value of a specific item. There are names in […]

Get the smallest number larger than a given number and a condition

This article demonstrates how to extract the largest number smaller than a given number based on a condition and criteria. […]

This article demonstrates how to extract the largest number smaller than a given number based on a condition and criteria. […]

Find the most recent date that meets a particular condition

This article demonstrates how to return the latest date based on a condition using formulas or a Pivot Table. The […]

This article demonstrates how to return the latest date based on a condition using formulas or a Pivot Table. The […]

Lookup min max values within a date range

This article explains how to find the smallest and largest value using two conditions. In this case they are date […]

This article explains how to find the smallest and largest value using two conditions. In this case they are date […]

Find the smallest number in a list that is larger than a given number

This article demonstrates formulas that lets you extract the smallest number larger than a given number. The example above specifies […]

This article demonstrates formulas that lets you extract the smallest number larger than a given number. The example above specifies […]