Get earliest date if 2 criteria is met

[sharky12345]

I'm trying to get the earliest date in a column if 2 criteria are met, this doesn't work and I get "00/01/1900");

=MIN(IF(OUTCOMES!$A$2:$A876="Base",OUTCOMES!$E$2:$E876="",OUTCOMES!$C$2:$C876))

The dates are in column C - the criteria is that the value in column A is "Base" and the cell in column E is blank.

Anyone?

 

[JimM]

Does this work

=MINIFS(C2:C876,A2:A876,"BASE",E2:E876,"")

 

[sharky12345]

Afraid not, I get a formula error #NAME?

 

[sandy666]

error #NAME?

so update your profile (Account details) about Excel version

 

[sharky12345]

2016

 

[sandy666]

you got this error because MINIFS function is for Excel for Office 365, Excel for Office 365 for Mac, Excel for the web, Excel 2019, Excel 2019 for Mac