Hi Excel Forum,

First time poster - as with a lot of questions, something similar has probably already been asked but could not find what I was looking for.

I'm looking for a formula to give me the oldest date (column C), with conditions from columns L and O, that appear 5 times or more only.

I had the below formula and then found it was picking up a few old outlier dates that are not relevant. I know I need a COUNTIF statement in here somewhere to achieve what I want.

=MINIFS('Data'!C2:C99999,'Data'!L2:L99999,"=McDonalds", 'Data'!O2:O99999,"=Burger").

Any help would be appreciated!