Assuming the data is text...

=COUNTIF(Range,"?*")