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

[MINIS2310]

Hi everyone,

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

Thanks,

Mins

I have 

[#2]

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

[#3]

@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.