Home

IF-MIN-SUMIFS function does not give the proper result

%3CLINGO-SUB%20id%3D%22lingo-sub-549734%22%20slang%3D%22en-US%22%3EIF-MIN-SUMIFS%20function%20does%20not%20give%20the%20proper%20result%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-549734%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20everyone%2C%3C%2FP%3E%3CP%3EI%20have%20a%20problem%20on%20this%20sheet.%20Any%20idea%20about%20how%20it%20may%20work%20properly.%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%2C%3C%2FP%3E%3CP%3EMins%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%26nbsp%3B%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20429px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F112631i5FFD71D6E41F851F%2Fimage-dimensions%2F429x476%3Fv%3D1.0%22%20width%3D%22429%22%20height%3D%22476%22%20alt%3D%22Screen%20Shot%202019-05-08%20at%2022.05.10.png%22%20title%3D%22Screen%20Shot%202019-05-08%20at%2022.05.10.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-549734%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-550262%22%20slang%3D%22en-US%22%3ERe%3A%20IF-MIN-SUMIFS%20function%20does%20not%20give%20the%20proper%20result%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-550262%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F338482%22%20target%3D%22_blank%22%3E%40MINIS2310%3C%2FA%3E%26nbsp%3BCan%20you%20explain%20what%20you%20are%20trying%20to%20achieve%3F%20What%20is%20the%20problem%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-550458%22%20slang%3D%22en-US%22%3ERe%3A%20IF-MIN-SUMIFS%20function%20does%20not%20give%20the%20proper%20result%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-550458%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F338482%22%20target%3D%22_blank%22%3E%40MINIS2310%3C%2FA%3E%26nbsp%3B%2C%20if%20you%20mean%20to%20find%20min%20date%20in%20AP%20against%20column%20C%20where%20values%20match%20row%20values%20from%20P%20to%20V%2C%20when%20it%20could%20be%20(in%20AQ30)%3C%2FP%3E%0A%3CPRE%3E%3DAGGREGATE(15%2C6%2C1%2F(C%3AC%3D%24P30%3A%24V30)%2F(C%3AC%26lt%3B%26gt%3B%22%22)*AP%3AAP%2C1)%3C%2FPRE%3E%0A%3CP%3EHowever%2C%20performance%20will%20be%20bad%20on%20entire%20columns.%3C%2FP%3E%0A%3CP%3EIn%20your%20locale%20you%20need%20to%20change%20commas%20on%20semicolons%20in%20above%20formula.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
MINIS2310
Occasional Visitor

Hi everyone,

I have a problem on this sheet. Any idea about how it may work properly. 

Thanks,

Mins

 

I have Screen Shot 2019-05-08 at 22.05.10.png

2 Replies
Highlighted

@MINIS2310 Can you explain what you are trying to achieve? What is the problem?

Highlighted

@MINIS2310 , if you mean to find min date in AP against column C where values match row values from P to V, when it could be (in AQ30)

=AGGREGATE(15,6,1/(C:C=$P30:$V30)/(C:C<>"")*AP:AP,1)

However, performance will be bad on entire columns.

In your locale you need to change commas on semicolons in above formula.

 

Related Conversations
Make Share function in Edge more useful
HotCakeX in Discussions on
2 Replies
function talking to table storage
donquijote in Compute on
0 Replies
Calculated column help
gopalaraoa in SharePoint on
1 Replies
Sumif help...
bvjsdfkv1690 in Excel on
3 Replies
SumIfs Help
bb94twins in Excel on
10 Replies