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: […]

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 […]