Countifs with multiple criteria
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