Poker Forum

Over 1,246,000 Posts!

REGISTER
Subscribe to FTR web feed
Already Registered?      Username:    Password:   Remember      Forgot Password

Poker Forum

  > 

FTR Community

  > 

I need EXCEL help!

  
 
LinkBack Thread Tools Display Modes
bode
Old 11-21-2006, 03:24 PM     Post subject: I need EXCEL help! #1 (permalink)  
bode's Avatar
Straight Flush

Join Date: May 2006
Location: slow motion
Posts: 4,270
bode is an unknown quantity at this point
Send a message via Skype™ to 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.
Quote:
eeevees are not monies yet...they are like baby monies.
 
Reply With Quote

Play for FREE and practice your game at...

Join the FTR Poker Forum to disable these banners and start posting!
Ash256
Old 11-21-2006, 03:43 PM #2 (permalink)  
4-of-a-Kind

Join Date: Mar 2006
Location: UK
Posts: 1,760
Ash256 will become famous soon enoughAsh256 will become famous soon enough
 Have seperate columns for MTT/SnGs, then we can start working it out.
Listen to my music
 
Reply With Quote
cobere
Old 11-21-2006, 04:11 PM #3 (permalink)  
cobere's Avatar
Flush

Join Date: Oct 2005
Location: Fort Collins
Posts: 336
cobere
Send a message via AIM to cobere Send a message via Yahoo to 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)
On moving up, properly rolled:
Quote:
Originally Posted by drmcboy
You don't know if you're J-Fish or A Fish until you try.
 
Reply With Quote
LeFou
Old 11-21-2006, 04:21 PM #4 (permalink)  
LeFou's Avatar
4-of-a-Kind

Join Date: Jul 2004
Location: Dallas, TX
Posts: 2,361
LeFou
countif is correct:
http://www.techonthenet.com/excel/formulas/countif.php

also
http://www.openoffice.org/
Reply With Quote
bode
Old 11-21-2006, 05:08 PM #5 (permalink)  
bode's Avatar
Straight Flush

Join Date: May 2006
Location: slow motion
Posts: 4,270
bode is an unknown quantity at this point
Send a message via Skype™ to 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.
Quote:
eeevees are not monies yet...they are like baby monies.
 
Reply With Quote
swiggidy
Old 11-21-2006, 06:05 PM #6 (permalink)  
swiggidy's Avatar
4-of-a-Kind

Join Date: Sep 2005
Location: Waiting in the shadows ...
Posts: 3,777
swiggidy will become famous soon enough
 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%.
(\__/)
(='.'=)
(")_(")
 
Reply With Quote
EasyT
Old 11-21-2006, 09:58 PM #7 (permalink)  
EasyT's Avatar
Full House

Join Date: Jan 2005
Location: Yo Mamma
Posts: 834
EasyT is on a distinguished road
Quote:
Originally Posted by Bode-ist
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
Reply With Quote
Reply
Latest Poker News
KoRnholio Old 05-26-2012, 03:08 PM    Australia Legalized Online Poker coming up in next 6 to 12 Months
According to an email sent out by Mark Bryan, a gaming analyst at Merrill Lynch, the Australian government plans to legalize online poker sometime in the next six to 12 months. This move will coincide ...

« Previous Thread | Next Thread »
Thread Tools
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


All times are GMT. The time now is 10:21 AM.

Contact Us - Archive - Top

FTR Testimonials

All content
© FlopTurnRiver.com 		Advertising  |   Partners  |   Testimonials  |   T&C  |   Contact Us  |   FTR News & Press  |   Site Map  |   Search FTR

Full Tilt  |   Titan Poker  |   UltimateBet  |   Poker Stars  |   Ladbrokes Bonus  |   Sportsbook  |   Cake Poker  

Play Texas Holdem Online, Online Texas Holdem Strategy, & Poker Forum
This is not a gambling website.