Excel Count Cells That Contain Text With "?"

Joined
Jun 30, 2017
Messages
1
Reaction score
0
Hello,

I have lists of names (each for one cell). Some of these are followed by a question mark (e.g. MARK ?).
I am struggling to find the correct formula that finds and counts all cells that contain the "?"

I am aware of the use of tilde for finding question marks (i.e. "~?") but for this specific case it does not work.

Any idea?

Thanks very much

Giulia
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Need Countifs Formula Help 0
Excel If a Cell Contains a Certain Text (From Another Table) 0
Excel Count If Formula Question 1
Excel Use COUNTIF across a range of cells with formulas 0
Excel Sum numbers in cells that also contain text 34
Excel A CountIF question... I think 2
Excel Count of Consecutive Data 0
Excel Sumproduct 0

Back
Top