Hi everyone, I am trying to get a value based on different values.
No Run Office QUALITY-CONTROL-EMPLOYEE No Run Office QUALITY-CONTROL-EMPLOYEE No Run Office QUALITY-CONTROL-EMPLOYEE Passed Office ANALYST No Run Office SECRETARY No Run Office SECRETARY No Run Office CEO Failed Office OFFICE LEAD Not Completed Office CEO
I need a formula that will give me a total for the "No Run", a total for "Passed", a total for "Failed" and a total for "Not Completed. Now comes the challenging part. The formula needs to check if the criteria "Office" in the second column is met, if it is met it will have to give me the total for "No Run" for example but only for unique values in column 3. So it should only give me a total of 3 for "No Run" because "No Run" only applies to three unique names in column 3.