General Betting
There is currently 1 person viewing this thread.
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 |
sort by:
Show
per page
Replies: 6
|
By:
try using the grouping/subtotal utility and use the count option for the qualifier column?
|
|
By:
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:
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:
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:
Thanks for the replies.
Your solution worked a treat Compound Magic. |
|
By:
This old thing!?
 |