Excell Spreadsheet Help - TranceAddict Forums

TranceAddict Forums (www.tranceaddict.com/forums)
- Chill Out Room
-- Excell Spreadsheet Help

Posted by Subey on Jul-25-2005 16:48:

Excell Spreadsheet Help

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

Posted by itsamemario on Jul-25-2005 17:11:

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

Posted by Vlad on Jul-25-2005 17:11:

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.

Posted by Krypton on Jul-25-2005 17:15:

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

Posted by Krypton on Jul-25-2005 17:16:

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.

Posted by Subey on Jul-25-2005 17:31:

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.

Posted by smokeape on Jul-26-2005 02:30:

Re: Excell Spreadsheet Help

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]]]

Posted by igottaknow on Jul-26-2005 02:50:

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"

Posted by Simcut on Jul-26-2005 04:16:

=COUNTIF(B2:T2;"yes")

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