May 28 2020 07:22 AM
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?
May 28 2020 07:42 AM
On which version of Excel you are? If Excel for Win Desktop that's at File->Account and looks like
May 28 2020 10:51 AM
@Sergei Baklan Hi thanks for the fast response. I am on Desktop version 2004 Build 12730.20352
May 28 2020 12:30 PM
Sorry for incorrect question, most important which channel is it plus is it English version of Excel or not.
May 28 2020 12:40 PM - edited May 28 2020 12:41 PM
May 28 2020 12:42 PM
Assuming that's English SKU
May 29 2020 08:37 AM
@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.
May 30 2020 06:41 AM
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.