Trending in Formulas and Functions
-
Reference sheet CountIf Contains
Hello, I am trying to build a reference sheet that gives a summary of quarterly results. I need to count the row if the value contains either Exception or Samples. I tried many different versions only getting many different error messages. This is my last attempt getting a Invalid Operation. =COUNTIF({2023 Q4 Monitoring},…
-
Calculating Formula help
My goal is if total number of students is 0 then it should equal number of students then in Total students the formula will be total number of students minus number of students
-
IF OR Statement
Hi There! Looking for help to on an IF OR statement. Want to take two columns that will be either Yes or No, and populate another column with a date from two columns if it is Yes. Process, either the Facilitator or the Architect will be requesting a Complete By Date. Whichever requests, the other has to say yes or no. For…