Looking to count the number of Stars

Anthonyhm · 12/10/18

Hello all,

I'm looking to count the number of "stars" within a column and have been testing with

=COUNTIF(check_column, "true"). This isn't working. Any ideas?

Andrée Starå · 12/10/18

Hi Anthony,

You'll have to use "1" for true and "0" for false.

Did it work?

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Paul Newcome · 12/10/18

You will also need square brackets [ ] around your column name.

Brian W · 12/10/18

I think you also need to complete the column range, right?

=COUNTIF([check_column]:[check_column], 1)

Anthonyhm · 12/11/18

Thank you everyone. Counting "stars" did not work.

I've changed the column data type to numbers.

Great support reactions here!!!

Andrée Starå · 12/11/18

Happy to help!

If you still want to use stars instead.

Try this.

=COUNTIF([Star Column]:[Star Column]; 1)

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

=COUNTIF([Star Column]:[Star Column], 1)

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

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Anitha · 06/30/21

I tried all possible trial and error, finally got my desired outcome with below. It counted exactly the number of stars in each of the columns in the range I provided.

((COUNTIF(Development1:Collaboration1, ="five") * 5) + (COUNTIF(Development1:Collaboration1, ="four") * 4) + (COUNTIF(Development1:Collaboration1, ="three") * 3) + (COUNTIF(Development1:Collaboration1, ="two") * 2) + (COUNTIF(Development1:Collaboration1, ="one") * 1))

Good Luck!!!

Andrée Starå · 06/30/21

Hi @Anitha

I hope you're well and safe!

Can you describe your process in more detail and maybe share the sheet(s)/copies of the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@workbold.com)

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!

Looking to count the number of Stars

Comments

Categories