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.
=COUNTIFS(Resolved:Resolved, IF(NOT(ISBLANK(Resolved:Resolved)), 1, 0))
You could try something like this...
=COUNTIFS(Resolved:Resolved, 0, [Call ID]:[Call ID], <> "")
Try something like this.
The same version but with the below changes for your and others convenience.
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!
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!
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.
Happy to help!
I saw that Paul answered already!
Let me know if I can help with anything else!