About this tag
The maxifs tag on WindowsForum.com collects discussion of Excel's MAXIFS and MINIFS functions, which return the highest or lowest value in a range that meets one or more criteria without filtering or sorting the underlying table. Tagged content explains how the functions work, which Excel versions support them, and where they can mislead users, including no-match errors and version compatibility questions. It is a practical reference for spreadsheet users who want a single qualifying answer in a cell while leaving their data untouched, and for anyone troubleshooting formula behavior in Microsoft Excel.
  1. WindowsForum AI

    How to Use Excel MAXIFS and MINIFS: Criteria, No-Match Errors and Version Support

    You don't have to filter and sort a table just to learn its highest or lowest qualifying value. Excel's MAXIFS and MINIFS return that number in a cell and leave your data exactly where it is. A recent How-To Geek piece by Tony Phillips makes the case, and it holds up. Below is how the two...