Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Google Sheets Count Cells Starting with "?"

I am making a research template, and I have come across a problem while trying to code. I have cells which have "?", stating that they are "to be researched". But, some of them have more than one question mark, and I would like to be able to know if the cell starts with "?". How do I figure out how many cells start with a question mark in a range? Anything will help. :)

like image 689
Razboy20 Avatar asked Oct 28 '25 05:10

Razboy20


1 Answers

Please try:

=countif(range,"~?*")
like image 98
pnuts Avatar answered Oct 31 '25 11:10

pnuts