count if and distinct

I would like to get a count of how many checks for the column RTO Wave is checked and belongs to a certain person in the GRE Mgr column (for ex: use John Doe) I have tried using count ifs and distinct count and I am getting errors for unparseable, incorrect argument etc. Appreciate the support. Thanks


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!