Count only outstanding items

Gary Brown · 06/14/19

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å · 06/14/19

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 · 06/17/19

Hi Andree,

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

Gary

Andrée Starå · 06/17/19

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

Count only outstanding items

Comments

Help Article Resources

Categories