COUNTIFS parsing error

Peggy

Hi,

I reviewed the other countifs suggestions, but i am still getting a parsing error. 

 

I am trying to count all rows that have EBS in range 1 where range 2 has only completed and in process.

=COUNTIFS({2018 TRACKER Range 1}, "EBS", {2018 TRACKER Range 2}, "Completed", {2018 TRACKER Range 2} "In Progress")

Nic Larsen

Your formula is missing a comma before "In Progress". 

Are you trying to count every time you have EBS in one column and Completed or In Progress in another column? 

Edit: Try this but with your column references.

=COUNTIFS([2018 Tracker]1:[2018 Tracker]5, "EBS", [Status Left]1:[Status Left]5, "Completed") + COUNTIFS([2018 Tracker]1:[2018 Tracker]5, "EBS", [Status Left]1:[Status Left]5, "In Progress")