Forum Discussion

Copper Contributor

Feb 24, 2022

MAXIFS Doesn't work on mac Laptop

Hi, I purchased Microsoft 365 with an intent to use the MAXIFS function. The problem is the function only returns a "#NAME" error on my mac laptop app. Peculiarly, the same spreadsheet with the same ...

excel

Formulas and Functions

travelaf

Copper Contributor

Feb 24, 2022

Thanks, however, I have the most current version of excel on Microsoft 365 (installed two days ago, and checked for updates - no new updates available) on my laptop. Why doesn’t MAXIFS work on my laptop?

Riny_van_Eekelen

Platinum Contributor

Feb 24, 2022

travelaf What exactly do you see when you click on Excel, About Microsoft Excel when in the Excel app on your Mac? Asking to be absolutely sure that we are on the same platform.

Mine shows this:

Can you also upload a screenshot with the formula visible in the formula bar when you click the cell that returns the Name error?

travelaf
Copper Contributor
Feb 25, 2022
Riny_van_Eekelen Thanks for your help! I noticed my version is 16.58 and yours is 16.59... I just "checked for updates" within Xcel this morning but the message said all apps are up to date. Could this be the problem, and if so, how can I force an update to 16.59?
- Riny_van_Eekelen
  Platinum Contributor
  Feb 25, 2022
  travelaf The formula looks OK and so does your Excel version. Don't know why it doesn't work for you.
  - travelaf
    Copper Contributor
    Feb 25, 2022
    OK, thanks, I updated my mac OS software and now Xcel works fine. Thanks for your help.