Archive for MAXIFS function
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 […]