+ Reply to Thread
Results 1 to 2 of 2

Couple of "COUNTIF" questions.

  1. #1
    Registered User
    Join Date
    09-23-2008
    Location
    Manc
    Posts
    1

    Couple of "COUNTIF" questions.

    Right, i am new here so hello! And thanks in advance for any advice given.

    I am putting together a little spreadsheet to help me keep track of my poker results. The first thing i need a little hand on is finding a formula to find the number of times i have come in the top ten. I am pretty sure this is a "COUNTIF" formula but i can quite figure it out.

    I have a entrant column and a place column. I need the formula to look in the entrants column and if the number is greater than BUT NOT EQUAL OR LESS THAN 9 then it looks in the place column. If in the place column the number is EQUAL TO OR LESS THAN 9 then it needs to count it.

    Also if you are very clever if you could make it appear so it is like below:

    First Number / Total Entries

    Total entries being EACH ENTRY IN THE ENTRANTS COLUMN ABOVE BUT NOT EQUAL TO 9.




    Next i need to find out where i come on average in two seperate types of tournament. It needs to take an average of ever number in the place column thats corresponding number in the entrants column is EQUAL TO OR LESS THAN 9.

    I am currently using this:

    =SUMIF(K7:K1005,"<=9",O7:O1005)/COUNTIF(K5:K7,">=9")

    But it just adds the numbers not averages them.

    The other one i need is just this one reversed so if i someone can just sort me the code for thes i can get editing. I just dont know where to start i got lost!

    If anyone has any assistance on this i would be very much appreciated. i have got everything else i - its just hese getting me stuck.

    Regards

    Sam
    Last edited by samfaction; 09-23-2008 at 09:59 AM.

  2. #2
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,902
    Welcome to our forum,

    Can you please take the time to read our forum rules. Your title needs to be amended so that it better describes the question you have.

    Also, please post only one question per thread.

    Thank you.
    Where there is a will there are many ways.

    If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner

    Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Couple of quick questions - VLOOKUP maybe?
    By Bakks in forum Excel General
    Replies: 8
    Last Post: 06-03-2008, 10:50 PM
  2. A couple of questions
    By kingdt in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-26-2007, 07:41 AM
  3. a couple of questions
    By moshmoshon in forum Excel General
    Replies: 2
    Last Post: 08-31-2007, 05:31 PM
  4. Counting Repetitive Questions and putting them in a chart
    By Matt_Smith in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 08-09-2007, 01:55 PM
  5. Couple of Excel Questions...
    By acerun007 in forum Excel General
    Replies: 3
    Last Post: 02-18-2007, 02:54 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1