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
Highlighted
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

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

@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
Extentions Synchronization
ChirmyRam in Discussions on
3 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
9 Replies