Excel date multiple criteria for Google Sheets

[Shail_Ach]

Hi,

Im trying to put a formula in H22 1st tab to take a minimum value/least or old date from date range (Col.J in 3rd tab) with multiple criteria like:
Considering row.2, Col.A, Col.D in 3rd tab

But below is the problem:
ErrorArray arguments to MAXIFS are of different size.

Pls help me fix

 

[Fluff]

Glad you sorted it & thanks for the feedback.