MS365 Subscriber and MAXIFS not available

%3CLINGO-SUB%20id%3D%22lingo-sub-1423878%22%20slang%3D%22en-US%22%3EMS365%20Subscriber%20and%20MAXIFS%20not%20available%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1423878%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20a%26nbsp%3BMS365%20subscriber%20and%20yet%20MAXIFS%20(and%20other%20advanced%20functions)does%20not%20appear%20to%20be%20available%20in%20spreadsheets%20on%20my%20local%20PC.%26nbsp%3B%20I%20tried%20changing%20the%20license%20to%20confirm%20and%20that%20did%20not%20work.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20suggestions%20to%20fix%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1423878%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1423953%22%20slang%3D%22en-US%22%3ERe%3A%20MS365%20Subscriber%20and%20MAXIFS%20not%20available%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1423953%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F682358%22%20target%3D%22_blank%22%3E%40SpringChook%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EOn%20which%20version%20of%20Excel%20you%20are%3F%20If%20Excel%20for%20Win%20Desktop%20that's%20at%20File-%26gt%3BAccount%20and%20looks%20like%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20515px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F195060i5B1EA32CC3BC7A25%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1424605%22%20slang%3D%22en-US%22%3ERe%3A%20MS365%20Subscriber%20and%20MAXIFS%20not%20available%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1424605%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3BHi%20thanks%20for%20the%20fast%20response.%20I%20am%20on%20Desktop%20version%202004%20Build%2012730.20352%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1424881%22%20slang%3D%22en-US%22%3ERe%3A%20MS365%20Subscriber%20and%20MAXIFS%20not%20available%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1424881%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F682358%22%20target%3D%22_blank%22%3E%40SpringChook%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ESorry%20for%20incorrect%20question%2C%20most%20important%20which%20channel%20is%20it%20plus%20is%20it%20English%20version%20of%20Excel%20or%20not.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1424904%22%20slang%3D%22en-US%22%3ERe%3A%20MS365%20Subscriber%20and%20MAXIFS%20not%20available%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1424904%22%20slang%3D%22en-US%22%3EThe%20MAXIFS%20and%20MINIFS%20are%20available%20in%20Office%202019%20ProPlus%20and%20all%20channels%20of%20Office%20365%20which%20is%20now%20Microsoft%20365.%3CBR%20%2F%3E%3CBR%20%2F%3EHowever%2C%20newer%20functions%20such%20as%20XLOOKUP%20and%20Dynamic%20Array%20Functions%20such%20ad%20FILTER%2C%20UNIQUE%2C%20SORT%2C%20SEQUENCE%20etc%20are%20currently%20available%20to%20users%20in%20Insider%20Program%20and%20Monthly%20Channel.%3CBR%20%2F%3E%3CBR%20%2F%3EIf%20you're%20on%20either%20Insiders%20or%20Monthly%20Channel%20and%20you%20do%20not%20have%20those%20functions%2C%20do%20click%20on%20Update%20Now%20in%20your%20Account%20under%20Product%20Information..%20They%20should%20be%20available%3CBR%20%2F%3E%3CBR%20%2F%3E%3CBR%20%2F%3ECheers%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1424908%22%20slang%3D%22en-US%22%3ERe%3A%20MS365%20Subscriber%20and%20MAXIFS%20not%20available%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1424908%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F421698%22%20target%3D%22_blank%22%3E%40Abiola1%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAssuming%20that's%20English%20SKU%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1426914%22%20slang%3D%22en-US%22%3ERe%3A%20MS365%20Subscriber%20and%20MAXIFS%20not%20available%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1426914%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3BHi%2C%20yes.%20I%20was%20'monthly%20channel'%20(English%20version%20I%20assume)%20desktop%20version.%20This%20morning%20I%20tried%20changing%20to%20'Beta%20channel'%20and%20installed%20the%20update.%20It%20still%20does%20NOT%20have%20MAXIFS%20available.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1428595%22%20slang%3D%22en-US%22%3ERe%3A%20MS365%20Subscriber%20and%20MAXIFS%20not%20available%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1428595%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F682358%22%20target%3D%22_blank%22%3E%40SpringChook%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIf%20you%20could%20provide%20screenshot%20of%20File-%26gt%3BAccount%20page%20or%20right%20part%20of%20it%20under%20Product%20information%2C%26nbsp%3B%20perhaps%20any%20idea%20could%20appear%20what%20could%20be%20wrong.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Hello,

 

I am a MS365 subscriber and yet MAXIFS (and other advanced functions)does not appear to be available in spreadsheets on my local PC.  I tried changing the license to confirm and that did not work.

 

Any suggestions to fix?

 

 

7 Replies
Highlighted

@SpringChook 

On which version of Excel you are? If Excel for Win Desktop that's at File->Account and looks like

image.png

Highlighted

@Sergei Baklan Hi thanks for the fast response. I am on Desktop version 2004 Build 12730.20352

Highlighted

@SpringChook 

Sorry for incorrect question, most important which channel is it plus is it English version of Excel or not.

Highlighted
The MAXIFS and MINIFS are available in Office 2019 ProPlus and all channels of Office 365 which is now Microsoft 365.

However, newer functions such as XLOOKUP and Dynamic Array Functions such ad FILTER, UNIQUE, SORT, SEQUENCE etc are currently available to users in Insider Program and Monthly Channel.

If you're on either Insiders or Monthly Channel and you do not have those functions, do click on Update Now in your Account under Product Information.. They should be available


Cheers
Highlighted

@Abiola1 

Assuming that's English SKU

Highlighted

@Sergei Baklan Hi, yes. I was 'monthly channel' (English version I assume) desktop version. This morning I tried changing to 'Beta channel' and installed the update. It still does NOT have MAXIFS available.

Highlighted

@SpringChook 

If you could provide screenshot of File->Account page or right part of it under Product information,  perhaps any idea could appear what could be wrong.