|
Excell Spreadsheet Help
|
View this Thread in Original format
| 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 |
|
|
| dj_alfi |
| 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 ;) |
|
|
| 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. |
|
|
| ::TranceVanDyk:: |
| sorry mate. u must have mathematical values put in. otherwise you'll just get error messages everytime. |
|
|
| ::TranceVanDyk:: |
| 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. |
|
|
| Subey |
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. |
|
|
| smokeape |
| 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]]] |
|
|
| igottaknow |
| quote: | Originally posted by dj_alfi
You have to download MS Blaster. Its a known problem, and this will fix it. |
+1 :stongue:
| quote: | Originally posted by Subey
I'm looking for help in Excell. Situation as follows. |
it's spelled "Excel" :wtf:
| 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 :eek:
ps his name isn't spelled collum its "gollum"
 |
|
|
| Simcut |
=COUNTIF(B2:T2;"yes")
wack that in a cell, this will look through cells B2 to T2 for anything that reads 'yes'
:) |
|
|
|
|
