Countif related

[devabharambe]

Dear team,

I am looking for a formula to count the month wise the maximum delivery date for each name, as referenced in the attached screenshot. Please share the expected result."

SUMPRODUCT(((TEXT(MAX(Table1[EDD first]),"mmm-dd")=TEXT(D$15,"mmm-dd"))+(TEXT(MAX(Table1[EDD Second]),"mmm-dd")=TEXT(D$15,"mmm-dd"))+(TEXT(MAX(Table1[EDD last]),"mmm-dd")=TEXT(D$15,"mmm-dd")))*(((Table1[Expdiotor]=$C16)+(Table1[inspector]=$C16)+(Table1[Field]=$C16))>0))

This formula use not getting result

 

[Peter_SSs]

Reminder:
Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Excel formula Help
There is no need to repeat the link(s) provided above but if you have posted the question at other places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.


I also suggest that you update your forum profile (click your user name at the top right of the forum, then ‘Account details’) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)