Count only outstanding items

Gary Brown

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. 

Andrée Starå

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!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Gary Brown

Hi Andree,

Unfortunately, that did not work. I got an "#invalid ref" result.

 

Gary

Andrée Starå

Ok.

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, andree@getdone.se)

Best,

Andrée