Count "green balls" within a range

Zoe McInerney

Hello

 

I'm am wanting to count "green balls" within a range.  I have used

 

=COUNTIF([Site Attended]11:[Site Attended]26), "green")

 

I'm have the result #unparsable

 

I am a new user so would apprecate the help.  Thank you

 

J. Craig Williams

You have one too many close paranthesis.

Try this instead

 

=COUNTIF([Site Attended]11:[Site Attended]26, "green")

 

Craig