Hey!

I'm looking for help in Excell. Situation as follows.

I have a SINGLE collum which has either an "X" or an "O" in it.
I would like to display the total # of Xs and the total number of Os in 2 seperate cells. Is there a formula that will do this?

Thanks

___________________
Светопресавление
your pearl casting hero

You have to download MS Blaster. Its a known problem, and this will fix it. Its a shareware proggie fix that you can find on any of the known p2p networks. Try to get the latest build and youll be ready to go

___________________
BA-DUM-TSS

quote:

ALFI - BOHICA - DJ MIX (Stream+Dropbox)

Do this... go to Edit, Find/Replace... Replace the O's with the number 1. Than in the seperate cell, use the formula =sum('select all the cells with the number 1') and it will add it up.

___________________
/SARCASM.

quote:

Originally posted by Coup Vlad wins. Flawless victory.

sorry mate. u must have mathematical values put in. otherwise you'll just get error messages everytime.

___________________

quote:

Originally posted by Vlad Do this... go to Edit, Find/Replace... Replace the O's with the number 1. Than in the seperate cell, use the formula =sum('select all the cells with the number 1') and it will add it up.

good idea. convert the x's and o's into mathematical values.

___________________

Thanks for the prompt replies... I'll fool around with your advice

edit: I did some searching in the forumla list, and "Countif" turned out to be exactly what I needed.

___________________
Светопресавление
your pearl casting hero

Last edited by Subey on Jul-25-2005 at 17:38

quote:

Originally posted by Subey Hey! I'm looking for help in Excell. Situation as follows. I have a SINGLE collum which has either an "X" or an "O" in it. I would like to display the total # of Xs and the total number of Os in 2 seperate cells. Is there a formula that will do this? Thanks

Use an If statement, like if cell = "X" , then value equals 1, else 0.


[[[smoke]]]

quote:

Originally posted by dj_alfi You have to download MS Blaster. Its a known problem, and this will fix it.

+1

quote:

Originally posted by Subey I'm looking for help in Excell. Situation as follows.

it's spelled "Excel"

quote:

I have a SINGLE collum which has either an "X" or an "O" in it. I would like to display the total # of Xs and the total number of Os in 2 seperate cells. Is there a formula that will do this?

BTW, excel isn't the preferred program for tic tac toe

ps his name isn't spelled collum its "gollum"

Last edited by igottaknow on Jul-26-2005 at 02:58

=COUNTIF(B2:T2;"yes")

wack that in a cell, this will look through cells B2 to T2 for anything that reads 'yes'

___________________
How can sound exist if there's no one there to hear it?

Last edited by Simcut on Jul-26-2005 at 11:57