View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mike Mike is offline
external usenet poster
 
Posts: 3,101
Default 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.-