Use CountIf() with symbols
 

I have a column were I insert certain symbols, for example X, and I need to
count how many of each symbol I have. I cannot use "X" in criteria, as Excel
doesn't recognize this as the X symbol. How can I solve this?

Thanks in advance.

Regards,
Emece.-

Use CountIf() with symbols
 

Use this it should work
=COUNTIF(A1:A4,"x")

"Emece" wrote:

I have a column were I insert certain symbols, for example X, and I need to
count how many of each symbol I have. I cannot use "X" in criteria, as Excel
doesn't recognize this as the X symbol. How can I solve this?

Thanks in advance.

Regards,
Emece.-