Count total of RYG balls

chris.italiano78351
edited 12/09/19 in Smartsheet Basics

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