Count total of RYG balls

03/29/19 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

 

 

ryg.PNG

Comments

  • Paul NewcomePaul Newcome ✭✭✭✭✭

    Very close! try something like this...

     

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

  • Andrée StaråAndrée Starå ✭✭✭✭✭
    edited 03/29/19

    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 PARTNER & CONSULTANT / EXPERT

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

    W: www.workbold.com | E: [email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.

  • Thank You Paul, It worked  - Much Appreciated!

     

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

  • Paul NewcomePaul Newcome ✭✭✭✭✭
    edited 03/29/19

    Happy to help. yes

     

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

  • Andrée StaråAndrée Starå ✭✭✭✭✭

    Happy to help!

    Best,

    Andrée

    SMARTSHEET PARTNER & CONSULTANT / EXPERT

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

    W: www.workbold.com | E: [email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.

  • Susie WachowskiSusie 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 NewcomePaul Newcome ✭✭✭✭✭

    @Susie Wachowski


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

  • Susie WachowskiSusie 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 NewcomePaul Newcome ✭✭✭✭✭

    What is your actual column name?

  • Susie WachowskiSusie Wachowski ✭✭✭✭✭

    Status

  • Paul NewcomePaul Newcome ✭✭✭✭✭

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

  • Susie WachowskiSusie Wachowski ✭✭✭✭✭

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

  • Paul NewcomePaul Newcome ✭✭✭✭✭

    Happy to help! 👍️

Sign In or Register to comment.