Countifs with multiple criteria

lesmickin ✭✭
edited 12/09/19 in Smartsheet Basics


I am trying to figure out a formula to capture a specific person and how many opened or closed cases they have.  

My fields are

Analyst and Date Closed

So for the analyst, let's say i am trying to find out how many cases Leslie King still has open, that would be annotated with the date closed field being blank, and then vice versa if the case was closed.  Any help would be appreciated