Excel: Conditional Formatting woes

[SAS]

This is probably easy to do, but I've not used excel in ages so could do with some help

Basically I have a row of data like: 1 x 1 1 1 x o x 1 1
and the cells, with conditional formatting change colour according to the value entered (1-green,o-yellow,x-red).

But I need to tally up the total of each symbols into a table. In this case:

1 - 6
o - 1
x - 3

But any idea what formula I could use to do this? I'm ripping my hair out agghgh

 

[babs]

=countif(a1:a10, "1") will give you 6. replace the "1" with "o" or "x" for the other results.

 

[WPKenny]

=countif(a1:a10, "1") will give you 6. replace the "1" with "o" or "x" for the other results.

Best tip eva!

 

[Jupitus]

I can't believe I got beaten to an Excel question thread by

WP(ieman)Kenny!!!!

*sobs*

 

[Xavier]

*ahem* jup - it was Babs who posted the tip - WPK just quoted it to give him props

 

[babs]

...and beaten by days.

 

[Jupitus]

Obviously in the wrong forum then, FFS.....

 

[Xavier]

I've no doubt you were