MAXIFS Doesn't work on mac Laptop

%3CLINGO-SUB%20id%3D%22lingo-sub-3207387%22%20slang%3D%22en-US%22%3EMAXIFS%20Doesn't%20work%20on%20mac%20Laptop%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3207387%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20I%20purchased%20Microsoft%20365%20with%20an%20intent%20to%20use%20the%20MAXIFS%20function.%20The%20problem%20is%20the%20function%20only%20returns%20a%20%22%23NAME%22%20error%20on%20my%20mac%20laptop%20app.%20Peculiarly%2C%20the%20same%20spreadsheet%20with%20the%20same%20function%20works%20perfectly%20on%20OneDrive%20Xcel%20when%20opened%20in%20my%20Chrome%20Browser%20instead%20of%20the%20desktop%20app.%20The%20desktop%20app%20is%20up%20to%20date%20(I%20installed%20it%20yesterday).%20Any%20ideas%20on%20how%20to%20get%20the%20MAXIFS%20function%20to%20work%20on%20my%20mac%20laptop%3F%3C%2FP%3E%3CP%3EThanks!%3C%2FP%3E%3CP%3EJason%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3207387%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3208192%22%20slang%3D%22en-US%22%3ERe%3A%20MAXIFS%20Doesn't%20work%20on%20mac%20Laptop%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3208192%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1314158%22%20target%3D%22_blank%22%3E%40travelaf%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMAXIFS%20is%20on%20the%20desktop%20version%20only%20available%20on%20Excel%202019%20or%20newer%20(2021%20or%20Microsoft%20365).%20If%20you%20use%20Excel%202016%20or%20older%20on%20your%20Mac%2C%20the%20function%20is%20not%20available%20and%20returns%20the%20%23NAME-error.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20Excel%20for%20the%20Web%20you%20get%20always%20the%20newest%20functionality%2C%20therefore%20it's%20working%20there.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3208825%22%20slang%3D%22en-US%22%3ERe%3A%20MAXIFS%20Doesn't%20work%20on%20mac%20Laptop%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3208825%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1314158%22%20target%3D%22_blank%22%3E%40travelaf%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fmaxifs-function-dfd611e6-da2c-488a-919b-9b6376b28883%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3EMAXIFS%20function%3C%2FA%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%3EThe%20function%20is%20suitable%20for%20Excel%20for%20Microsoft%20365%2C%20Excel%20for%20Microsoft%20365%20for%20Mac%2C%20Excel%20for%20the%20web%2C%20Excel%202021%2C%20Excel%202021%20for%20Mac%2C%20Excel%202019%2C%20Excel%202019%20for%20Mac.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fhow-to-correct-a-name-error-b6d54e31-a743-4d7d-9b61-40002a7b4286%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3EHow%20to%20correct%20a%20%23NAME%3F%20error%3C%2FA%3E%3C%2FP%3E%3CP%3EThe%20top%20reason%20why%20the%20%23NAME%3F%20error%20appears%20in%20the%20formula%20is%20because%20there%20is%20a%20typo%20in%20the%20formula%20name.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%3EIf%20you%20have%20an%20older%20version%20of%20Excel%20on%20the%20laptop%2C%20try%20the%20following%20formula%3A%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%3E%3DMAX(IF((A1%3AA5%3DC1)%3BB1%3AB5))%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%3ECell%20F1%20contains%20the%20name%20for%20which%20the%20maximum%20is%20to%20be%20searched.%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22%22%3E%3CSPAN%3ESince%20the%20formula%20is%20an%20array%20formula%2C%20complete%20the%20entry%20with%20%E2%8C%98%20-%20Enter.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20I%20was%20able%20to%20help%20you%20with%20this%20information.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fexcel-blog%2Fmeet-niko-chatzoudis-excel-forum-contributor%2Fba-p%2F2941385%22%20target%3D%22_blank%22%3ENikolinoDE%3C%2FA%3E%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3209334%22%20slang%3D%22en-US%22%3ERe%3A%20MAXIFS%20Doesn't%20work%20on%20mac%20Laptop%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3209334%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1314158%22%20target%3D%22_blank%22%3E%40travelaf%3C%2FA%3E%26nbsp%3BWhat%20exactly%20do%20you%20see%20when%20you%20click%20on%20Excel%2C%20About%20Microsoft%20Excel%20when%20in%20the%20Excel%20app%20on%20your%20Mac%3F%20Asking%20to%20be%20absolutely%20sure%20that%20we%20are%20on%20the%20same%20platform.%3C%2FP%3E%3CP%3EMine%20shows%20this%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screenshot%202022-02-24%20at%2014.29.27.png%22%20style%3D%22width%3A%20315px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F350991iD421F76C3B767A4B%2Fimage-dimensions%2F315x431%3Fv%3Dv2%22%20width%3D%22315%22%20height%3D%22431%22%20role%3D%22button%22%20title%3D%22Screenshot%202022-02-24%20at%2014.29.27.png%22%20alt%3D%22Screenshot%202022-02-24%20at%2014.29.27.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3ECan%20you%20also%20upload%20a%20screenshot%20with%20the%20formula%20visible%20in%20the%20formula%20bar%20when%20you%20click%20the%20cell%20that%20returns%20the%20Name%20error%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

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 function works perfectly on OneDrive Xcel when opened in my Chrome Browser instead of the desktop app. The desktop app is up to date (I installed it yesterday). Any ideas on how to get the MAXIFS function to work on my mac laptop?

Thanks!

Jason

6 Replies

@travelaf 

MAXIFS function

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.

How to correct a #NAME? error

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.

 

NikolinoDE

I know I don't know anything (Socrates)

 

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?

@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:

Screenshot 2022-02-24 at 14.29.27.png

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

@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?

@travelaf The formula looks OK and so does your Excel version. Don't know why it doesn't work for you.

 

OK, thanks, I updated my mac OS software and now Xcel works fine. Thanks for your help.