Forum Discussion

MINIS2310's avatar
MINIS2310
Copper Contributor
May 08, 2019

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

Hi everyone,

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

Thanks,

Mins

 

I have 

excel
Formulas and Functions

2 Replies

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    May 08, 2019

    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.