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.
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 ?
=COUNTIF()
=COUNTIFS()
Put this formula:
=COUNTIF(A:A,"*~?")
To count only for a specific group:
=COUNTIFS(A:A,"*~?",B:B,"unix")
When you are managing a team, “how to be a good manager” is the “must”...
As manager, I am doing many reports, even when I was an ITIL consultant, I still needed to do many reports...
ITIL V3 is going to be obsolete...
Managing an IT service when I start a new company is not an easy task, particularly true, if the service...