I have a Request Management sheet with a Form that we used to track tasks.  They template came with a Metric sheet that is very useful.  One of the metrics on this Metrics sheets counts items by assigned person.  I want to update that to count only items that are not Closed status.  Current formula is: =COUNTIF({Request Tracker Range 3}, Category20)   How do I update this to show only non Closed statuses?  The metrics are pulled into a graphic on a Dashboard. 




Hi Gary,

Try something like this.

=COUNTIFS({Request Tracker Range 3}, Category20,{Request Range for status},NOT(@cell="Closed"))

Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.

Did it work?

Have a fantastic weekend!


Andrée Starå

Workflow Consultant @ Get Done Consulting


In reply to by Gary Brown


Can you paste the formula you used and if possible a screenshot of the sheets?

Can you describe your process in more detail and maybe share the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, [email protected])