About this tag
The minifs tag on WindowsForum.com collects discussion of Microsoft Excel's MINIFS function, the criteria-based formula that returns the smallest value in a range while matching one or more conditions. Tagged content walks through how MINIFS and its companion MAXIFS work, which Excel versions support them, and where they can mislead users, including no-match errors and version compatibility questions. Because the topic sits inside Excel rather than Windows itself, the coverage is practical and spreadsheet-focused, aimed at readers who want a single qualifying answer without filtering or sorting their data first.
  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...