Find cell value with 99%

David Clunie

Hi,

Is there a way to find and count every cell which equals 99%?

Andrée Starå

Hi @David Clunie

I hope you're well and safe!

Yes.

Try something like this. (replace with your column name)

=COUNTIF([ColumnWith99%Value]:[ColumnWith99%Value], 0.99)

Did that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

David Clunie

Hi Andree

I figured this out my % wasn't actually 99% . It was, in fact, 99.40% when increasing decimal places.

=COUNTIFS({*Levels}, =1, {Percentage}, 0.994)

Thanks

Andrée Starå

Hi @David Clunie

I hope you're well and safe!

Yes.

Try something like this. (replace with your column name)

=COUNTIF([ColumnWith99%Value]:[ColumnWith99%Value], 0.99)

Did that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

David Clunie

Hi Andree

Thanks for the recommendation; however, this has not produced what I expected.

I have a separate sheet that grabs the information from my master to populate a dashboard. It firstly looks a reference called level which gets the row that I require if data = 1(I basically have level identifiers to show hierarchy within a branch of a grandparent,parent-child projects)

I am then looking for the Percentage column within that row, which is rolling up all subtasks to reach an overall % of the project completed.

I have at least 33 projects in my master planner at 99%, but I cannot find them?

It can find projects at 100% if I change the value to 1 or subsequently find 50 projects not started at 0% if I default the value to ,0).

=COUNTIFS({ Levels}, =1, {Percentage}, 0.99) FInds 0 projects and there should be 33

=COUNTIFS({Levels}, =1, {Percentage}, 1) Finds 1 project

=COUNTIFS({Levels}, =1, {Percentage}, 0) Finds 50 projects

David Clunie

Hi Andree

I figured this out my % wasn't actually 99% . It was, in fact, 99.40% when increasing decimal places.

=COUNTIFS({*Levels}, =1, {Percentage}, 0.994)

Thanks

Andrée Starå

@David Clunie

Excellent!

Easy to miss!

You're more than welcome!