COUNTIF syntax - count if specific word in cell

dianay ✭✭✭
edited 12/09/19 in Smartsheet Basics

I'm trying to count every cell in a column that has a specific word (the word "Store") in it, but I keep getting an "Incorrect Argument Set" error.

This is my formula syntax - what needs to be corrected?

=COUNTIF([Location Type]:[Location Type] = "Store")

The name of the column is "Location Type" and I would like for the function to search every row in this column. Thank you.