How would I count non started cells

How would I count non started cells

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-

Best Answer

Answers

  • Andrée Starå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!

    Best,

    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD

  • 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-

  • Andrée Starå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 

    Best,

    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD

Sign In or Register to comment.