Newbie needs Excel suggestions with a simple script

0 votes

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: enter image description here

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:enter image description here

Feb 7, 2023 in Others by Kithuzzz
• 38,020 points
469 views

1 answer to this question.

0 votes

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

=SUM(LEN(range)-LEN(SUBSTITUTE(range,"a","")))
answered Feb 7, 2023 by narikkadan
• 63,720 points

Related Questions In Others

0 votes
1 answer

Execute a shell script with php

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

answered Feb 24, 2019 in Others by Omkar
• 69,230 points
9,401 views
0 votes
1 answer

Excel - IF Formula with a FIND

What about using mid() to see if ...READ MORE

answered Sep 27, 2022 in Others by narikkadan
• 63,720 points
687 views
0 votes
1 answer

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

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

answered Sep 30, 2022 in Others by narikkadan
• 63,720 points
1,213 views
0 votes
1 answer

MS Excel - Concat with a delimiter

Use TEXTJOIN() instead: =TEXTJOIN(";",TRUE,A1:A2000) I hope this ...READ MORE

answered Oct 2, 2022 in Others by narikkadan
• 63,720 points
573 views
0 votes
1 answer

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

answered Oct 3, 2022 in Others by narikkadan
• 63,720 points
897 views
0 votes
1 answer

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

answered Oct 3, 2022 in Others by narikkadan
• 63,720 points
1,867 views
0 votes
1 answer

How to simplify adding multiple countifs formula in excel

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

answered Nov 26, 2022 in Others by narikkadan
• 63,720 points
600 views
0 votes
1 answer

Excel: Count distinct numerical values if string condition matches

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

answered Feb 10, 2023 in Others by narikkadan
• 63,720 points
431 views
0 votes
1 answer

How to create a drop-down in excel with custom values

You can accomplish that using code rather ...READ MORE

answered Sep 25, 2022 in Others by narikkadan
• 63,720 points
1,004 views
0 votes
1 answer

Excel OFFSET function with a dynamic row argument

The answer is to make "anchor cells" ...READ MORE

answered Sep 26, 2022 in Others by narikkadan
• 63,720 points
1,005 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP