I need EXCEL help!

[bode]

ive working on a new spreadsheet for tracking Sngs and MTTs and i cant figure out something that seems like it should be fairly standard.

I have a column with the type of game (i.e. Sng, MTT, Cash) and a column for ITM (yes/no).

im trying to separate ITM for Sng's and ITM for MTTs.

example:

Game ITM
MTT yes
Sng yes
Sng no
MTT no
Sng yes
etc, etc.

what formula do i use to find the number of Sngs ITM or MTTs ITM?

i thought it was a "COUNTIF" function, but cant get it to work. any help would be much appreciated.

[Ash256]

Have seperate columns for MTT/SnGs, then we can start working it out.

[cobere]

I was getting ready to change the yes/no in my spreadsheet to 1 or 0 for ITM. Then your countif function should work, and you can also build pivot tables that show the sum of ITM for each category (SNG or MTT)

[LeFou]

countif is correct:
http://www.techonthenet.com/excel/formulas/countif.php

also
http://www.openoffice.org/

[bode]

thanks for all of the quick responses

the countif function only lets you put in one column for criteria, not 2.

the only sollution i had managed before was changing the Yes/No to 1/0 as cobere suggested. i think ill just do this for now.

[swiggidy]

The way I did it was make a column for the amount won, if I finished OTM I left it blank, so just counting the cells with a number gives #ITM, counting the cells where an entry fee was paid gives #Tourney. I use these 2 to calculate ITM%.

[EasyT]

thanks for all of the quick responses

the countif function only lets you put in one column for criteria, not 2.

the only sollution i had managed before was changing the Yes/No to 1/0 as cobere suggested. i think ill just do this for now.

CountIf will get the job done...eventually. It will likely take a couple of calculations. CountIf using one criteria, and then also Count the cells. Subtract and/or divide to get a percentage. It's getting complicated, but it's not that hard.

If you email me your sheet and spell out exactly what you would like it to do, I can set it up for you quickly and send it back.

***************************

For anyone else interested, I also have published my Bankroll Tracker free for anyone to pick up. It's not too complicated, though it does include a neat function to adjust automatically if you deposit in foreign currencies, and also has a place to keep track of BR spending.

EasyT's BankRoll Tracker (Excel)
Discussion of EasyT's BR Tracker


EasyT