Forums

General Betting

There is currently 1 person viewing this thread.
top2rated
23 Jun 10 08:21
Joined:
Date Joined: 28 Feb 04
| Topic/replies: 12,258 | Blogger: top2rated's blog
Would like to add a couple of extra columns, one to count the number of qualifiers per race (as there are sometimes multiple qualifiers ) and another column to count the number of qualifiers per day.  The spreadsheet is set up as shown below.  Any advice appreciated.  Thanks.

    Time        Date        Course        Qualifier        ISP        Position        Runners   
    15:00        22/06/10        Brighton        Seneschal        50        1st        8   
    16:00        22/06/10        Brighton        Prince Valentine        12        5th        14   
    16:45        22/06/10        Beverley        Commander Wish        11        8th        12   
    17:15        22/06/10        Beverley        Divine Spirit        14        5th        13   
    18:20        22/06/10        Newbury        Princess Flame (GER)        33        9th        11   
    15:15        21/06/10        Lingfield        Cativo Cavallino        25        1st        8   
    18:50        21/06/10        Chepstow        Stamford Blue        22        3rd        14   
    17:20        20/06/10        Hereford        Phoenix Eye        40        9th        12   

Post your reply

Text Format: Table: Smilies:
Forum does not support HTML
Insert Photo
Cancel
sort by:
Show
per page
Replies: 6
By:
waynebrayn
When: 23 Jun 10 08:43
try using the grouping/subtotal utility and use the count option for the qualifier column?
By:
Equimine.co.uk
When: 23 Jun 10 09:40
If you are using Excel 2007 you could use the COUNTIFS function.

=COUNTIFS(A$2:A$9,A$2,B$2:B$9,B$2,C$2:C$9,C$2,D$2:D$9,"*")

The "*" asterisk at the last condition will establish if the cell is empty or has text.
By:
Compound Magic
When: 23 Jun 10 17:17
First answer count the Qualifiers in a certain race ~
=SUMPRODUCT((A$2:A$50=A2)*(B$2:B$50=B2)*(C$2:C$50=C2))

Second answer count qualifiers for day ~
=COUNTIF(B$2:B$50,B2)
By:
Compound Magic
When: 23 Jun 10 17:26
You have to put those formula in 2 columns and
fill down. If you go past row 50 change 50's in the
formula to 100 or 1,000 whatever the case may be.
By:
top2rated
When: 23 Jun 10 17:39
Thanks for the replies.

Your solution worked a treat Compound Magic.
By:
s.kenbo
When: 05 Jan 17 17:34
This old thing!? Wink
sort by:
Show
per page

Post your reply

Text Format: Table: Smilies:
Forum does not support HTML
Insert Photo
Cancel
‹ back to topics
www.betfair.com