Counting a cell if it has a specific word

Connie Cochran
Connie Cochran ✭✭✭✭
edited 04/26/23 in Smartsheet Basics

I trying to write a formula that says count if the word red appears in the column.

I tried =COUNTIF([All screeners present at event],="Red") but I'm getting an error


Never mind, I got it =COUNTIF([REPORTING All screeners present at event]:[REPORTING All screeners present at event], "Red")

Answers