Please vote to add expressions inside Maxifs & minifs functions

%3CLINGO-SUB%20id%3D%22lingo-sub-2630365%22%20slang%3D%22en-US%22%3EPlease%20vote%20to%20add%20expressions%20inside%20Maxifs%20%26amp%3B%20minifs%20functions%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2630365%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20all%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Esometimes%20in%20maxifs%20%26amp%3B%20minifs%20we%20need%20to%20use%20an%20expression%20instead%20of%20range%2C%20but%20this%20doesnt%20work%2C%20can%20you%20please%20vote%20for%20this%20feature%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fexcel.uservoice.com%2Fforums%2F304921-excel-for-windows-desktop-application%2Fsuggestions%2F43969428-allow-to-have-an-expression-inside-maxifs-minifs%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fexcel.uservoice.com%2Fforums%2F304921-excel-for-windows-desktop-application%2Fsuggestions%2F43969428-allow-to-have-an-expression-inside-maxifs-minifs%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2630365%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-2634002%22%20slang%3D%22en-US%22%3ERe%3A%20Please%20vote%20to%20add%20expressions%20inside%20Maxifs%20%26amp%3B%20minifs%20functions%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2634002%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F258847%22%20target%3D%22_blank%22%3E%40chahine%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThese%20days%20in%20many%20cases%20FILTER()%20is%20used%20instead%20of%20SOMEIFS()%20functions%2C%20like%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-code-sample%20language-excel-formula%22%3E%3CCODE%3E%3DMAX(FILTER(Revenue-Expenses%2CYear%3D2020))%3C%2FCODE%3E%3C%2FPRE%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Contributor

Hello all

 

sometimes in maxifs & minifs we need to use an expression instead of range, but this doesnt work, can you please vote for this feature

 

https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/43969428... 

1 Reply

@chahine 

These days in many cases FILTER() is used instead of SOMEIFS() functions, like

=MAX(FILTER(Revenue-Expenses,Year=2020))