'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Fix MINIFS and MAXIFS Functions Unavailable in Excel
Question details
The user is unable to find or utilize the MINIFS and MAXIFS functions for data calculations in their Excel workbook.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Attempting to calculate minimum or maximum values based on multiple conditions using the built-in MINIFS or MAXIFS functions.
- Observed behavior
- The MINIFS and MAXIFS functions do not appear in the autocomplete list, cannot be found in the Insert Function menu, or return a #NAME? error when typed manually.
Before troubleshooting, ensure you have an active internet connection to download any pending Office updates and save your current workbook to prevent data loss.
Check and Update Your Microsoft Office Version
Updating your Office suite is the most common fix, as MINIFS and MAXIFS are only available in supported versions like Microsoft 365 or specific newer builds (e.g., version 2111 or 2302).
Microsoft introduced the MINIFS and MAXIFS functions in Office 365 and Excel 2019. If you are running an older standalone version or a pending update is stuck, the functions will remain unavailable until the software is brought up to date.
Launch Microsoft Excel, click on 'File' in the top-left corner, and select 'Account' from the left sidebar.
Under the Product Information section, click the 'Update Options' button next to Office Updates.
Select 'Update Now' from the dropdown menu. Wait for Microsoft Office to download and install the latest updates, then restart Excel to see if the functions are now available.
Search for Formulas via the Insert Function Tool
Use the built-in search feature to force Excel to locate the function, bypassing potential autocomplete display glitches.
Use WPS Office to Access Advanced Spreadsheet Functions for Free
If your current version of Microsoft Excel does not support MINIFS and MAXIFS and you want to avoid paying for an expensive upgrade, WPS Office is an excellent solution. It is a free, lightweight alternative that offers extensive compatibility with modern spreadsheet formulas, allowing you to seamlessly continue your advanced data analysis.
- 1. Download WPS Office: Visit the official WPS website to download and install the free WPS Office suite on your computer.
- 2. Open Your Spreadsheet: Launch WPS Spreadsheet and open your existing Excel workbook (.xlsx file).
- 3. Apply the Functions: Select an empty cell and type '=MINIFS(' or '=MAXIFS(' to utilize the multi-condition formulas immediately.
Frequently Asked Questions
Can I use MINIFS and MAXIFS in Excel 2016 or 2013?
No, the MINIFS and MAXIFS functions are not natively available in standalone older versions like Excel 2016 or Excel 2013. They were introduced in Excel 2019 and Microsoft 365.
What is the alternative to MINIFS in older versions of Excel?
If you are using an older version, you can simulate MINIFS by using an array formula that combines the MIN and IF functions. For example: =MIN(IF(criteria_range=criteria, min_range)). You must press Ctrl+Shift+Enter to evaluate it as an array formula.
Why is my MINIFS formula returning a #NAME? error?
The #NAME? error occurs when Excel does not recognize the function text. This usually means you have misspelled the function name, or you are opening a modern workbook in an outdated version of Excel that does not support the MINIFS or MAXIFS features.
