Forum Discussion
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 ...
The function is suitable for Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2019 for Mac.
The top reason why the #NAME? error appears in the formula is because there is a typo in the formula name.
If you have an older version of Excel on the laptop, try the following formula:
=MAX(IF((A1:A5=C1);B1:B5))
Cell F1 contains the name for which the maximum is to be searched. Since the formula is an array formula, complete the entry with ⌘ - Enter.
Hope I was able to help you with this information.
I know I don't know anything (Socrates)