How would I count non started cells

Nick Armendariz

I'm trying to count the number of non-resolved cells that use a star symbol, filled in resolved, unresolved not filled. Want to exclude blank cells.

I tried:

=COUNTIFS(Resolved:Resolved, IF(NOT(ISBLANK(Resolved:Resolved)), 1, 0))

Thanks,

Nick-

Paul Newcome

You could try something like this...

=COUNTIFS(Resolved:Resolved, 0, [Call ID]:[Call ID], <> "")

Andrée Starå

Hi Nick,

Try something like this.

=COUNTIF(Resolved:Resolved; 1)

The same version but with the below changes for your and others convenience.

=COUNTIF(Resolved:Resolved, 1)

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

Did it work?

I hope that helps!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post help answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Nick Armendariz

That will get me all of the marked "filled in" stars but I'm wanting to count the unmarked "not filled in" ones.

When set the formula to "0" =COUNTIF(Resolved:Resolved, 0), it comes back to all unchecked(unfilled) stars and blank cells in the column. I get 44 when I want to see 4, circled in image.

Thanks,

Nick-

Paul Newcome

You could try something like this...

=COUNTIFS(Resolved:Resolved, 0, [Call ID]:[Call ID], <> "")

Andrée Starå

Happy to help! 

I saw that Paul answered already!

Let me know if I can help with anything else!

Best, 

Andrée