MINIFS Function in Office Standard

%3CLINGO-SUB%20id%3D%22lingo-sub-1940438%22%20slang%3D%22en-US%22%3EMINIFS%20Function%20in%20Office%20Standard%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1940438%22%20slang%3D%22en-US%22%3E%3CP%3EIt%20appears%20we%20are%20running%20into%20a%20problem%20between%20Excel%20versions.%26nbsp%3B%20We%20have%20a%20Remote%20Desktop%20Server%20with%20Excel%20Standard%202016%20installed%20and%20the%20rest%20of%20the%20company%20is%20on%20M365%20version.%26nbsp%3B%20It%20appears%20the%20MINIFS%20function%20is%20not%20available%20in%20the%20Standard%20version.%26nbsp%3B%20Does%20anyone%20know%20how%20to%20verify%20this%3F%26nbsp%3B%20Thanks%20for%20the%20help.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1940438%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1940493%22%20slang%3D%22en-US%22%3ERe%3A%20MINIFS%20Function%20in%20Office%20Standard%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1940493%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F885674%22%20target%3D%22_blank%22%3E%40msvt22%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAccording%20to%20this%20page%2C%20MINIFS%20became%20available%20with%20Excel%202019%26nbsp%3B%20%3CA%20href%3D%22https%3A%2F%2Fexceljet.net%2Fexcel-functions%2Fexcel-minifs-function%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fexceljet.net%2Fexcel-functions%2Fexcel-minifs-function%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

It appears we are running into a problem between Excel versions.  We have a Remote Desktop Server with Excel Standard 2016 installed and the rest of the company is on M365 version.  It appears the MINIFS function is not available in the Standard version.  Does anyone know how to verify this?  Thanks for the help.

2 Replies

@msvt22 

 

According to this page, MINIFS became available with Excel 2019  https://exceljet.net/excel-functions/excel-minifs-function

 

 

@msvt22 

In addition, all functions could be checked here Excel functions (alphabetical)