Count total of RYG balls

chris.italiano78351

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

 

 

Paul Newcome

Very close! try something like this...

 

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

Andrée Starå

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

chris.italiano78351

Thank You Paul, It worked  - Much Appreciated!

 

chris.italiano78351

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

Paul Newcome

Happy to help.

 

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

Andrée Starå

Happy to help!

Best,

Andrée

Susie Wachowski

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:

Paul Newcome

@Susie Wachowski

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

Susie Wachowski

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"))

Paul Newcome

What is your actual column name?

Susie Wachowski

Status

Paul Newcome

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

Susie Wachowski

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

Paul Newcome

Happy to help! 👍️