Min If formula

[Michael van den Berg]

How do i get the Min If formula to work with more than 2 criteria?
I tried the aproach below but it gives a zero value, even when corrected for zero's.
Can you guys spot a problem with my formula below?

{=MIN(IF((tabel1[Activity]=$U14)*(tabel1[Number]=$A$6)*(tabel1[Year]=$A$9)*(tabel1[Date]<>0);tabel1[Date]))}

 

[Somendra Misra]

Hi,

Please upload a sample file.

Regards,

 

[Michael van den Berg]

Sorry, here it is.
Tried to make a simple version.
Text is dutch though.

 

[Somendra Misra]

Hi,

Convert your date column from text to real number or use below formula
=MIN(IF((Tabel1[Activiteitgroep]=$H$2)*(Tabel1[Cliëntnummer]=$H$3)*(Tabel1[Fiscaal jaar]=$H$4)*(Tabel1[Datum]<>0),DATEVALUE(Tabel1[Datum])))

With ctrl+Shift+Enter.

Regards,

 

[Hui]

Try:

1. Convert the Date Column to Dates, they are currently Text
2. Use the formula: =MIN(IF((Tabel1[Activiteitgroep]=$H$2)*(Tabel1[Cliëntnummer]=$H$3)*(Tabel1[Fiscaal jaar]=$H$4)>0,Tabel1[Datum],FALSE))

 

[Michael van den Berg]

The dates were text. I completely overlooked checking that.
Thanks Hui for spotting it for me!

I would give you a cookie if I could!

 

[Hui]

You should also thanx Somendra
He beat me to it by a minute

 

[Michael van den Berg]

I only noticed the last entry.
Somendra thanks for your help