I use to be able to do this but now seems like i forgot

I want sum up values based on words in a column. For example in a
column I want to aassign a value of 1 for every word in the column that
has Kentucky

This is the equation that used ot work for excel

{=SUM((D6:D67="Kentucky")*(1))+SUM((D6:D67="Washington")*(1))}

however when i try to modify the equation or click on ti

it becomes

=SUM((D6:D67="Kentucky")*(1))+SUM((D6:D67="Washington")*(1))

and i get this error

#VALUE!

Where does the { } come from and how to correct the problem.