ExcelBanter - count special characters

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - count special characters (https://www.excelbanter.com/excel-worksheet-functions/184168-count-special-characters.html)

Gaurav[_2_]

count special characters

I have tried countif but it does not work.

so...if i have to count that in a column how many are there and how many <
are there...what function should be used?

Gaurav[_2_]

count special characters

i was doing something wrong...it worked not
=COUNTIF($B$1:$B$9,"=")

"Gaurav" wrote in message
...
I have tried countif but it does not work.

so...if i have to count that in a column how many are there and how many
< are there...what function should be used?

porter444

count special characters

=SUMPRODUCT(--(A2:A10=""))+SUMPRODUCT(--(A2:A10="<"))

"Gaurav" wrote:

I have tried countif but it does not work.

so...if i have to count that in a column how many are there and how many <
are there...what function should be used?

Rick Rothstein $MVP - VB$[_332_]

count special characters

Give this formula a try (it should work for any text string, not just
individual special characters)...

=SUMPRODUCT(LEN(B1:B9)-LEN(SUBSTITUTE(B1:B9,"<","")))/LEN("<")

or, put the text to find in a cell, say, C1...

=SUMPRODUCT(LEN(B1:B9)-LEN(SUBSTITUTE(B1:B9,C1,"")))/LEN(C1)

Rick

"Gaurav" wrote in message
...
I have tried countif but it does not work.

so...if i have to count that in a column how many are there and how many
< are there...what function should be used?

All times are GMT +1. The time now is 02:43 PM.