Forum Discussion

JohnTaylor20

Copper Contributor

Jul 04, 2022

asdasdsadsa

ddfdsfdfdsfsdfsdf

excel

Formulas and Functions

JohnTaylor20

Copper Contributor

Jul 04, 2022

=SUMPRODUCT(ISNUMBER(FIND({"yes;approved"},LOWER(Table[comment])))*(YEAR(Table[date])=YEAR(TODAY()))*(WEEKNUM(Table[date]+0)=WEEKNUM(TODAY())))

it didnt work, the result is 0

SergeiBaklan

Diamond Contributor

Jul 04, 2022

JohnTaylor20

Perhaps you mean

=SUMPRODUCT(--(MMULT( 
     ISNUMBER(FIND({"yes", "approved"},LOWER(Table[comment]))),
     {1;1} ) > 0 )  *
   (YEAR(Table[date])=YEAR(TODAY()))*
   (WEEKNUM(Table[date]+0)=WEEKNUM(TODAY())))