I have a column that sometimes has B and sometimes B - somecomment. I want to count all instances of B. I expected it to be something like
=COUNTIF(B14:B943, LEFT(B14:B943,1) = "B")
But no dice. What am I missing? Is there a better way to solve this problem?