Count question mark with a formula in an excel report

It seems easy but not at all, if my cells have only the question mark “?”, it is a simple formula but if my cells are a question like that “group1 ?”, the simple formula will not work so to get the result I need to add 2 extra characters into the formula.

macro excel


When I use the formula ?

To count how many questions.


How to use the formula ?

The formula in this topic is with "," so depending of the operating system of your PC, the formula should have ";" instead of ",".


How are the formulas ?



Put this formula:


To count only for a specific group:


Interesting Management