LinkBack URL
About LinkBacks
I am helping a coworker with a project. We are both operating Excel 2016. My computer has the built in formulas MAXIFS and MINIFS, but his does not. Does anyone know why this would be and how to fix it? Thanks!
I am helping a coworker with a project. We are both operating Excel 2016. My computer has the built in formulas MAXIFS and MINIFS, but his does not. Does anyone know why this would be and how to fix it? Thanks!
Hi TFiske,
MINIFS and MAXIFS are only available to subscribers of OFFICE 365 with current version of EXCEL 2016. The standalone version of EXCEL 2016 does not have these new formulas.
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
As mentioned above, many functions introduced into Excel 2016 are now subscription based in that without an Office 365 subscription they are not available.
MS lists those changes and updates available to subscribers here
Generally speaking, unless you know that everyone using that file is a subscriber, I would avoid those functions and features that require it. This is a similar, albeit grander, issue as was presented between many past versions in terms of new formulas/features being incompatible. For example there was a time when the *IFS functions (sumifs, countifs, averageifs) were new and didnt work in older versions of Excel, at which time it was advisable to use the older methods of accomplishing the same thing for compatibility until most/all people upgraded.
The problem faced now is this isnt a matter of everyone "moving the line forward" by upgrading software. Unless they subscribe to a service they may not need, they could potentially never have access to some of these formulas/features. It will great a void between those subscribing and those not.
Ways to get help: Post clear questions, explain your overall goal, supply as much background as possible, respond to questions asked of you by those trying to help and post sample(s) files.
"I am here to help, not do it for people" -Me
Yeah just use the {MAX(IF)} construction instead, if you can accept having array formulas in your spreadsheet.
Click the [* Add Reputation] Button to thank people for help!
Post Attachment: Click [Go Advanced] under the reply box; then click [Manage Attachments] to launch the attachments dialogue.
Mark Thread Solved: Go to the top of the first post; Select [Thread Tools] dropdown; Pick the [Mark thread as Solved] option.
Ya, I will from now on. So that array construction would be something like:Yeah just use the {MAX(IF)} construction instead, if you can accept having array formulas in your spreadsheet.
{=MAX(IF(criteria_range=criteria,max_range))}
I just assumed that since the whole company uses Office365, everyone would have it. Apparently, my coworker is operating in a different paradigm. Thanks!
One alternative is to use AGGREGATE function, e.g.Originally Posted by TFiske
=AGGREGATE(14,6,max_range/(criteria_range=criteria),1)
which doesn't require "array entry" - for MIN change 14 to 15
Audere est facere
Can you elaborate?
I am using Office 2010 and often have to make a MAXIF construct as {MAX(IF(range=criteria;maxrange))}
I tried replacing with your code but it didn't work..
works
Please Login or Register to view this content.
doesn't work.Please Login or Register to view this content.
sagar_ap welcome to the forum
Administrative Note:
Welcome to the forum.
We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original. Please start a new thread - See Forum rule #4
If you are not familiar with how to start a new thread see the FAQ: How to start a new thread
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 2 users browsing this thread. (0 members and 2 guests)
Posting Permissions
Register To Reply
Bookmarks