# Count total of RYG balls

Options
edited 12/09/19

Hi, can someone please help me - I am trying to count the total of Red, Yellow and Green Balls in a column and cant get my formula to work. Currently my formula reads

=COUNTIFS([Status2]4:[Status2]33, "GREEN", "YELLOW", "RED")

thank you

• ✭✭✭✭✭✭
Options

Very close! try something like this...

=COUNTIFS([Status2]4:[Status2]33, OR(@cell = "Red", @cell = "Yellow", @cell = "Green"))

• ✭✭✭✭✭✭
edited 03/29/19
Options

Hi Chris,

Try this.

=COUNTIF([Status2]4:[Status2]33; "GREEN") + COUNTIF([Status2]4:[Status2]33; "YELLOW") + COUNTIF([Status2]4:[Status2]33; "RED")

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

=COUNTIF([Status2]4:[Status2]33, "GREEN") + COUNTIF([Status2]4:[Status2]33, "YELLOW") + COUNTIF([Status2]4:[Status2]33, "RED")

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

Did it work?

Have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

SMARTSHEET EXPERT CONSULTANT & PARTNER

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

W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

• Options

Thank You Paul, It worked  - Much Appreciated!

• Options

Thanks Andrea, appreciate the help - Tried Both you and Pauls, both worked. Thanks heaps

• ✭✭✭✭✭✭
edited 03/29/19
Options

Happy to help.

Looks like Andree and I were typing up solutions at about the same time. Hahaha

• ✭✭✭✭✭✭
Options

Happy to help!

Best,

Andrée

SMARTSHEET EXPERT CONSULTANT & PARTNER

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

W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

• Options

I want to do the same thing but I couldn't get the formulas to work. I'm in the States. Can you send me a formula suggestion for this:

• ✭✭✭✭✭✭
Options

My formula above should work for you. What exactly are you trying to accomplish and what results are you getting?

• Options

I'm trying to count the number of green, yellow, and red balls in the Status column. I'm getting a #UNPARSEABLE error message. This is the formula I modified to count rows 3-142 in the Status column: =COUNTIFS([Status1]3:[Status1]142, OR(@cell = "Red", @cell = "Yellow", @cell = "Green"))

• ✭✭✭✭✭✭
Options

What is your actual column name?

• Options

Status

• ✭✭✭✭✭✭
Options

Try using your actual column name instead of [Status1]. That should clear it up for you.

• Options

Ahh yes, that was the secret, thank you!!

• ✭✭✭✭✭✭
Options

Happy to help! 👍️