I want to search on a specific column in an excel file. I'm curious how frequently a particular "letter/character" has been utilised. It's the letter "x" in my instance. I eventually came across this formula after some research:

```=COUNTIF(D2:D48,"FIDELIO")
```

the problem here is, I always get an error message:

If I write the Code with an " ` " in front like this:

````=COUNTIF(D2:D48,"FIDELIO")
```

Excel simply writes the code to me as text rather than as code.

Tried to write the Code with an "`" in front like this:

````=COUNTIF(D2:D48,"FIDELIO")
```

Excel then simply writes me the code as text rather than as a code. Here is a more image:

Feb 7, 2023 in Others 306 views

## 1 answer to this question.

Formula to Count the Number of Occurrences of a Single Character in a Range

`=SUM(LEN(range)-LEN(SUBSTITUTE(range,"a","")))`
• 63,420 points

## Execute a shell script with php

One of the possible reason for this ...READ MORE

## Excel use SUMIF but with a multiplier before summation: x2, x3, x4, etc

The product of the sum and the ...READ MORE

## Excel COUNTIF "Column D" year equals 2015 and Column L equals "15 or greater"

COUNTIFS() with an S allows the ability of multiple ...READ MORE

## Excel Formula Query on Summing Annual Leave Days and Half Days

Try Something like =SUM(COUNTIF(\$A\$1:\$A\$8,"A"),COUNTIF(\$A\$1:\$A\$8,"HA")/2) - total count ...READ MORE

## How to simplify adding multiple countifs formula in excel

If the Excel version you are using ...READ MORE

## Excel: Count distinct numerical values if string condition matches

FILTER Shipper and Month based on Employee ...READ MORE