count one column based on a different filtered column

hmcnamara95571 ✭✭✭✭
edited 12/09/19 in Formulas and Functions


I have a list of staff names in one column and another column with task statuses (Not Started, In Progress, Complete).  I'd like to find how many In Progress and Not Started tasks each staff member has.  I've tried COUNTIF and COUNTIFS but can't quite get the formula right.  All of the examples I'm finding are looking for blank cells and none of mine are blank.  I know this is incorrect but it's the closest I've come.....   

=COUNTIF({Credentialing Tasks - Staff}, {Credentialing Tasks Status<>"Complete"})

Any ideas please?

Thank you!



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!