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.