How to use the MAXIFS function

The MAXIFS function allows you to calculate the highest value based on a condition or criteria. Formula in cell G4: […]

Find latest date based on a condition

Table of contents Lookup a value and find max date How to enter an array formula Explaining array formula Download […]

Lookup min max values within a date range

This post demonstrates how to find minimum and maximum value using two conditions. In this case they are date conditions […]