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,"")))

	A	B	C	D	E
1	Member	Claim #	Invoice Date	Yes / No	Claim Paid in # Days
2	12	123	8/1/18	Yes	> 14 Days and <= 30 Days
3	42	321	8/20/18	Yes	<= 14 Days
4	36	112	8/2/2018	Yes	> 14 Days and <= 30 Days
5	41	115	8/18/2018	Yes	<= 14 Days

<tbody>
</tbody>

 

[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")