Check out our brand new Local Poker Communities! Get updates and interact with poker players in your area.
Visit the United States Poker Community | Visit the California Poker Community | Read more about the Launch of P5s Local

A question for any Microsoft Excel Geeks

Reply to Thread
  1. SoCalDrew SoCalDrew is offline Moderator

    Dallas, TX
    United States

    Posts: 14,285
    Joined: Sep 05

    May 2nd, 2006 (5/2/2006 6:34pm)

    I myself am an Excel junkie. I just have yet to harness its full power.

    Question:

    In my “Poker Results” excel file, I keep track of game, type of game, and buy-in (and many other things).

    Is it possible for me to draw the average buy-in based on a combination of game and type?

    For example, I have one results sheet and one summary sheet. I want to have a cell in my “summary” sheet that will show the average buy-in of ONLY NLH MTTs, as labeled in my “results” sheet.

    The only way I know how to do this is to sort the “results” sheet first by MTT, then by NLH to get NLH MTTs together and then on my “summary” sheet manually set the range to be averaged as, for example, B2:B10…

    I would like to automate this as much as possible. If I could write a function to only average those NLHMTTs, it would save a lot of time and make it easier to run different reports and see where strengths and weaknesses were.

    Thanks for any assistance or advice.
     
  2. minnman minnman is offline

    Phoenix, AZ
    United States

    Posts: 157
    Joined: Sep 05

    May 2nd, 2006 (5/2/2006 6:40pm) in reply to SoCalDrew

    Can't you use a SUMIF function and just put the criteria you want? I'm not sure how your database is organized but I think just using SUMIF should work.
  3. SoCalDrew SoCalDrew is offline Moderator

    Dallas, TX
    United States

    Posts: 14,285
    Joined: Sep 05

    May 2nd, 2006 (5/2/2006 6:43pm) in reply to minnman

    I do the SUMIF to count the number of those types of entries. Now I would like to use a function like AVERAGEIF to average the buy-in amounts, but they don't have that as far as I can tell.
     
    Thread Starter
  4. jesterwords jesterwords is offline

    Posts: 20,674
    Joined: Jan 06

    May 2nd, 2006 (5/2/2006 8:09pm) in reply to SoCalDrew

    =average(SUMIF(A2:A18,"=NLH MTT",B2:B18))

    CHANGE YOUR RANGE FOR FIRST PART TO THE COLUMN THAT HAS NLH MTT, CHANGE THE 2ND ONE TO THE COLUMN THAT HAS YOUR BUY IN.

    -JESTER
  5. jasmith85 jasmith85 is offline

    United States

    Posts: 4,085
    Joined: Nov 05

    May 2nd, 2006 (5/2/2006 8:53pm) in reply to SoCalDrew

    PM 1.21gigawatts or clizzark they can help you
Reply to Thread

Similar Threads