Countifs with multiple criteria

lesmickin

Hello,

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

Marcel M

Open:

=COUNTIFS(Analyst:Analyst; ="Leslie King"; [Date Closed]:[Date Closed]; ="")

Closed:

=COUNTIFS(Analyst:Analyst; ="Leslie King"; [Date Closed]:[Date Closed]; <>"")

 

"" (two quotation marks) means empty

<> means not equal

so <>"" is [not empty]

 

Hope this helps

 

Best regards,

Marcel

lesmickin

Thank you.  I just tried it and it comes up as unparseable.  Doe it matter that it's pulling the name from a contact field?

Paul Newcome

Try swapping the semicolons for commas. Some regions have a different symbol used between formula sections.

lesmickin

Thank you soooo much! 

 

Paul Newcome

Happy to help!