Combining MIN IF

[rchansen2001]

I am trying to use the MIN formula to return the oldest date from column C if the two IF statements are true. Example of data below.

I have tried the following formulas in Excel 2010 but they didn't return the correct information. Any help is greatly appreciated.

=MIN(IF(D:D="Yes",AND(E:E="<= 14 Days",C:C,"")))
=MIN(IF(AND(D:D="Yes",(E:E="<= 14 Days"),C:C,""))
=MIN(IF(D:D="Yes",IF(E:E="<= 14 Days",C:C,"")))


[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Member[/TD]
[TD]Claim #[/TD]
[TD]Invoice Date[/TD]
[TD]Yes / No[/TD]
[TD]Claim Paid in # Days[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]12[/TD]
[TD]123[/TD]
[TD]8/1/18[/TD]
[TD]Yes[/TD]
[TD]> 14 Days and <= 30 Days[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]42[/TD]
[TD]321[/TD]
[TD]8/20/18[/TD]
[TD]Yes[/TD]
[TD]<= 14 Days[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]36[/TD]
[TD]112[/TD]
[TD]8/2/2018[/TD]
[TD]Yes[/TD]
[TD]> 14 Days and <= 30 Days[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]41[/TD]
[TD]115[/TD]
[TD]8/18/2018[/TD]
[TD]Yes[/TD]
[TD]<= 14 Days[/TD]
[/TR]
</tbody>[/TABLE]

 

[lrobbo314]

How about this? =MIN(IF((D2:D5="Yes")*(E2:E5="<= 14 Days"),C2:C5))

This is an array formula, so control+shift+enter.

 

[rchansen2001]

How about this? =MIN(IF((D2:D5="Yes")*(E2:E5="<= 14 Days"),C2:C5))

This is an array formula, so control+shift+enter.

@lrobbo314

My original formula worked when I tried control+shift+enter.

Thanks for your input.

 

[Aladin Akyurek]

@lrobbo314

My original formula worked when I tried control+shift+enter.

Thanks for your input.

The ones with AND in them won't work.

If you have MINIFS on your Excel, invoke a formula with that function for reasons of efficiency...

=MINIFS(C:C,D:D,"Yes",E:E,"<= 14 Days")