=COUNTIF(B2:B15,"Cooking Dinner") Returns all count Cooking Dinners =SUMPRODUCT(1*(YEAR(A2:A15)=2023)) Returns all count of year 2023 I would like to count how many times “Cooking Dinners” is in the year 2023. Or count all “Cooking” in the year 2024 no matter of if it is lu...
I suppose getting the date formatting right would be one way to solve this, but then I suppose an alternative solution might be to create a comprehensive list of months, and then merge the data within the Power Query tool with this list? In that way, even if Exc...
Rule 1>> Select the values in columns D & E >> Home Tab >> Conditional Formatting >> New Rule >> Use Formula To determine which cell to format >> in the Formula box type: =COUNTIF($C$2:$C$5,$D2&$E2)>=1 then >> Hit Format >> Fill Tab >> Yellow >> OK >>Ok Rule 2>...
LOOKUP(2,1/(COUNTIF($H$1:H1,$C$2:$C$30)=0),$A$2:$A$30)), "") and similar in G2 =IFERROR( IFERROR( IFERROR(LOOKUP(2,1/(COUNTIF($F$1:F1,$A$2:$A$30)=0),$B$2:$B$30), LOOKUP(2,1/(COUNTIF($G$1:G1,$B$2:$B$30)=0),$B$2:$B$30)), LOOKUP(2,1...
=IF(COUNTIF(A2:E2;"*text1*")+COUNTIF(A2:E2;"*text2*");"Yes";"No") In case you ever need to expand the formula with more text matches, perhaps this one is a bit easier to maintain: =IF(SUM(IFERROR(FIND({"text1";"text2"};A2:E2),0));"Yes","No")...
John in Québec As variant The problem is that SEARCH returns an error value if the term is not found. So if the student answers anything but "survey", the first SEARCH causes the entire formula to return an error; the rest of the formula isn't evaluated. ...
=SUM(COUNTIF(F2,"*"&{"survey","survay","servay"} &"*")*{1,0.8,0.5}) jtjohnston_quebec It works If you are on Excel which doesn't support dynamic arrays try to use SUMPRODUCT() instead of SUM(). Please check the file attached....
=COUNTIF(B2:B15,"Cooking Dinner") Returns all count Cooking Dinners =SUMPRODUCT(1*(YEAR(A2:A15)=2023)) Returns all count of year 2023 I would like to count how many times “Cooking Dinner...
=COUNTIF(B2:B15,"Cooking Dinner") Returns all count Cooking Dinners =SUMPRODUCT(1*(YEAR(A2:A15)=2023)) Returns all count of year 2023 I would like to count how many times “Cooking Dinner...
=COUNTIF(B2:B15,"Cooking Dinner") Returns all count Cooking Dinners =SUMPRODUCT(1*(YEAR(A2:A15)=2023)) Returns all count of year 2023 I would like to count how many times “Cooking Dinner...