• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Excel formula Help

I am using this formula
=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)) but not getting proper result

Regards
Deva
 
Try:
Code:
=SUMPRODUCT(BYROW(Table1[[Expdiotor]:[Field]],LAMBDA(a,OR($C16=a)))*BYROW(Table1[[EDD first]:[EDD last]],LAMBDA(a,OR(D$15=a))))
 
Back
Top