Excel 2016 Pro Plus--I am missing new functions (i.e. MaxIfs, TextJoin)?


I have Office 365 Pro Plus installed on a Windows 10 Pro machine.

I have Office 2016 with all the updates installed.

In Excel Pro Plus I don't have the new functions such as MaxIfs, MinIfs, TextJoin, IFs, Concat. I have tried to reinstall Office with no success. 

On my work laptop I use Excel 2016 Business via Office 365 Business Edition and do have access to these functions. Also have accesss to them via Excel online.

I know some of you must be thinking I downloaded Office 2013 instead, but that is not the case. 

Any ideas? Thanks!

Excel 64 Bit. Version: 16.0.6001.1078


You are one of many who are confused by this matter - it took me weeks to sort it out.

The Business version of Office 365 has various update options - not so with Home & Student

One setting (First Release --- see screenshot) causes all new function to be incorporated on a monthly basis rather than 3 monthly.

The update setting is controlled by the account manager -- and it takes some searching to find the spot!

The new functions are available to all with Excel Online

best wishes

A Guide to MS Excel 2013 for Scientists and Engineers

3 people found this reply helpful

Was this reply helpful?


Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.


Question Info

Last updated May 11, 2021 Views 8,091 Applies to: