General Betting

Welcome to Live View – Take the tour to learn more

Start Tour

‹ back to topics

There is currently 1 person viewing this thread.

Spreadsheet help please

top2rated

23 Jun 10 08:21

Joined:

Date Joined: 28 Feb 04

| Topic/replies: 17,850 | 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

Pause • Switch to Standard View Spreadsheet help please

Report waynebrayn • June 23, 2010 8:43 AM BST

try using the grouping/subtotal utility and use the count option for the qualifier column?

Report Equimine.co.uk • June 23, 2010 9:40 AM BST

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.

Report Compound Magic • June 23, 2010 5:17 PM BST

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)