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

 

[Shail_Ach]

Screenshots of the issue attached

 

[Fluff]

Are you trying to do this in Excel or Sheets?

 

[Shail_Ach]

Are you trying to do this in Excel or Sheets?

sheets

 

[Fluff]

In future when you are asking for a solution that is not for Excel, please clearly say so & post in the General Discussion & Other Applications section of the board.
I have done that for you this time.

 

[Shail_Ach]

In future when you are asking for a solution that is not for Excel, please clearly say so & post in the General Discussion & Other Applications section of the board.
I have done that for you this time.

sorry my bad. Thanks

 

[Fluff]

What are you trying to do with the last part of that formula?

 

[Shail_Ach]

What are you trying to do with the last part of that formula?

I want to filter J2 from row 2 (criteria range) in tab.3 with C22 criteria in tab.2

 

[Fluff]

I'm afraid that means nothing to me. At the moment you are getting the max value from col J if col A=C5 & col D =C21. where does that final part come in?

 

[Shail_Ach]

I'm afraid that means nothing to me. At the moment you are getting the max value from col J if col A=C5 & col D =C21. where does that final part come in?

Wow. you questioning me made me question myself with the query. Found the solution. Thanks a ton for the help