count if and distinct

Catherine Shea

ss6.23.JPG

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

John Pudar

Hi @Catherine Shea. Try this:

=COUNTIFS([RTO Wave - GRE Checklist Required If Checked]:[RTO Wave - GRE Checklist Required If Checked], =1, [GRE Mgr]:[GRE Mgr], "John Doe")