Can I CountIF just the green balls in a Status Column
I want to just get a count on all the green balls in the RYG symbols in my status column?
This is the formula I am trying: =COUNTIF([Status]2:[Status87], "Green"
It returns #UNPARSEABLE. Then the RYG turn greens, it means the person RSVP. So on my dashboard I am trying to to 5 out 86 people have responded. Any help with a formula would be appreciated.