Results 1 to 29 of 29

Count with two criteria

Threaded View

SpareBank1 Count with two criteria 10-05-2009, 05:30 PM
whallgren Re: How to count with 2... 10-05-2009, 06:11 PM
SpareBank1 Re: How to count with 2... 10-05-2009, 06:20 PM
SpareBank1 Re: How to count with 2... 10-06-2009, 07:20 AM
DonkeyOte Re: How to count with 2... 10-06-2009, 07:48 AM
SpareBank1 Re: How to count with 2... 10-06-2009, 10:42 AM
DonkeyOte Re: How to count with 2... 10-06-2009, 10:50 AM
SpareBank1 Re: Count with two criteria 10-07-2009, 01:58 PM
SpareBank1 Re: Count with two criteria 10-08-2009, 05:06 PM
  1. #1
    Registered User
    Join Date
    10-05-2009
    Location
    Lofoten, Norway
    MS-Off Ver
    Excel 2007
    Posts
    19

    Count with two criteria

    Hi,
    I have a dataset with odds for soccermatches, and results.
    I want to count each time a specified odds has won the match, but i cannot find out which formula to use.

    For example:

    HTeam ATeam Res H-Odds D-Odds A-Odds
    1.Team1 Team2 H 1.60 2.10 4.30
    2.Team1 Team2 D 1.64 2.30 3.30
    3.Team1 Team2 H 1.60 2.60 4.35
    4.Team1 Team2 A 3.10 2.80 1.60
    5.Team1 Team2 A 1.60 2.10 3.30
    6.Team1 Team2 D 1.60 1.60 4.30

    HTeam= Home team
    ATeam= Away team
    Res = Result, Home, Draw, or Away
    H-Odds= Home odds
    D-Odds= Draw odds
    A-Odds= Away odds

    Defining my problem:
    I want to count the times the odds; 1.60 was the winning odds.
    I imagine i need to set up 3 columns: Homewins, Draws, Awaywins.

    Kind of like:
    =COUNTIF(A1:A50,"1.60"),IF(B1:B50,"H")
    like that, only that is not correct

    Can anyone help me?
    Last edited by SpareBank1; 10-05-2009 at 05:47 PM.

Thread Information

Users Browsing this Thread

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

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