Use CountIf() with symbols

E

Emece

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.-
 
E

Emece

Thanks to both of your for your replies.

I wasn't clear enough. Sorry for that, and I will try to explain it better.

I insert icons, like the ones you can now use in Conditional Formatting in
Excel 2007 (Icon Sets). So when I use the CountIf Function, it doesn't work
just using X, because I have a red X that it is an icon.

Hope it is clear now.

Thanks again.

Regards,
Emece.-
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top