Here's more text to explain your ask.
"Quotes"
Testing"Quotes"
Testing " Quotes "
=COUNTIF({column}, "Value")
@GenTest2