Sub total block range for fieldsize .

[Sunline]

Hello all ,

I am trying to get a function that can give me the result I have in col S (Fsz) .

The result should come by looking at the three cols E F and counting col R for final result .

Sometimes there are three meetings in one day and as on rows 44 and 45 Ellerslie was
abandoned on 6/09/14 after race 1 . Riccarton straight after starts at R#1 col R but should not be
counted with Ellerslies abandoned meeting . Reasoning for meeting name .

There can never be duplicates due to for ever changing and increasing dates .

Hope this is clear .
Thanks .

Excel Workbook
	D	E	Q	R
1	Meet	Date	R#	Fsz
2	Tauranga	5/09/2014	1	8
3	Tauranga	5/09/2014	1	8
4	Tauranga	5/09/2014	1	8
5	Tauranga	5/09/2014	1	8
6	Tauranga	5/09/2014	1	8
7	Tauranga	5/09/2014	1	8
8	Tauranga	5/09/2014	1	8
9	Tauranga	5/09/2014	1	8
10	Tauranga	5/09/2014	2	3
11	Tauranga	5/09/2014	2	3
12	Tauranga	5/09/2014	2	3
13	Tauranga	5/09/2014	3	11
14	Tauranga	5/09/2014	3	11
15	Tauranga	5/09/2014	3	11
16	Tauranga	5/09/2014	3	11
17	Tauranga	5/09/2014	3	11
18	Tauranga	5/09/2014	3	11
19	Tauranga	5/09/2014	3	11
20	Tauranga	5/09/2014	3	11
21	Tauranga	5/09/2014	3	11
22	Tauranga	5/09/2014	3	11
23	Tauranga	5/09/2014	3	11
24	Ellerslie	6/09/2014	1	21
25	Ellerslie	6/09/2014	1	21
26	Ellerslie	6/09/2014	1	21
27	Ellerslie	6/09/2014	1	21
28	Ellerslie	6/09/2014	1	21
29	Ellerslie	6/09/2014	1	21
30	Ellerslie	6/09/2014	1	21
31	Ellerslie	6/09/2014	1	21
32	Ellerslie	6/09/2014	1	21
33	Ellerslie	6/09/2014	1	21
34	Ellerslie	6/09/2014	1	21
35	Ellerslie	6/09/2014	1	21
36	Ellerslie	6/09/2014	1	21
37	Ellerslie	6/09/2014	1	21
38	Ellerslie	6/09/2014	1	21
39	Ellerslie	6/09/2014	1	21
40	Ellerslie	6/09/2014	1	21
41	Ellerslie	6/09/2014	1	21
42	Ellerslie	6/09/2014	1	21
43	Ellerslie	6/09/2014	1	21
44	Ellerslie	6/09/2014	1	21
45	Riccarton Park	6/09/2014	1	7
46	Riccarton Park	6/09/2014	1	7
47	Riccarton Park	6/09/2014	1	7
48	Riccarton Park	6/09/2014	1	7
49	Riccarton Park	6/09/2014	1	7
50	Riccarton Park	6/09/2014	1	7
51	Riccarton Park	6/09/2014	1	7
52	Riccarton Park	6/09/2014	2	9
53	Riccarton Park	6/09/2014	2	9
54	Riccarton Park	6/09/2014	2	9
55	Riccarton Park	6/09/2014	2	9
56	Riccarton Park	6/09/2014	2	9
57	Riccarton Park	6/09/2014	2	9
58	Riccarton Park	6/09/2014	2	9
59	Riccarton Park	6/09/2014	2	9
60	Riccarton Park	6/09/2014	2	9
61	Riccarton Park	6/09/2014	3	14
62	Riccarton Park	6/09/2014	3	14
63	Riccarton Park	6/09/2014	3	14
64	Riccarton Park	6/09/2014	3	14
65	Riccarton Park	6/09/2014	3	14
66	Riccarton Park	6/09/2014	3	14
67	Riccarton Park	6/09/2014	3	14
68	Riccarton Park	6/09/2014	3	14
69	Riccarton Park	6/09/2014	3	14
70	Riccarton Park	6/09/2014	3	14
71	Riccarton Park	6/09/2014	3	14
72	Riccarton Park	6/09/2014	3	14
73	Riccarton Park	6/09/2014	3	14
74	Riccarton Park	6/09/2014	3	14
75	Riccarton Park	6/09/2014	4	5
76	Riccarton Park	6/09/2014	4	5
77	Riccarton Park	6/09/2014	4	5
78	Riccarton Park	6/09/2014	4	5
79	Riccarton Park	6/09/2014	4	5
80	Riccarton Park	6/09/2014	5	11
81	Riccarton Park	6/09/2014	5	11
82	Riccarton Park	6/09/2014	5	11
83	Riccarton Park	6/09/2014	5	11
84	Riccarton Park	6/09/2014	5	11
85	Riccarton Park	6/09/2014	5	11
86	Riccarton Park	6/09/2014	5	11
87	Riccarton Park	6/09/2014	5	11
88	Riccarton Park	6/09/2014	5	11
89	Riccarton Park	6/09/2014	5	11
90	Riccarton Park	6/09/2014	5	11
91	Riccarton Park	6/09/2014	6	7
92	Riccarton Park	6/09/2014	6	7
93	Riccarton Park	6/09/2014	6	7
94	Riccarton Park	6/09/2014	6	7
95	Riccarton Park	6/09/2014	6	7
96	Riccarton Park	6/09/2014	6	7
97	Riccarton Park	6/09/2014	6	7
Sheet1

 

[Sunline]

Sorry for bump , hoping someone might have a solution to my problem .
Thanks .

 

[shg]

	D​	E​	Q​	R​	S​
1​	Meet​	Date​	R#​	Fsz​
2​	Tauranga	05/09/2014​	1​	8​	R2: =COUNTIFS(D:D, D2, E:E, E2, Q:Q, Q2)
3​	Tauranga	05/09/2014​	1​	8​
4​	Tauranga	05/09/2014​	1​	8​
5​	Tauranga	05/09/2014​	1​	8​
6​	Tauranga	05/09/2014​	1​	8​
7​	Tauranga	05/09/2014​	1​	8​
8​	Tauranga	05/09/2014​	1​	8​
9​	Tauranga	05/09/2014​	1​	8​
10​	Tauranga	05/09/2014​	2​	3​
11​	Tauranga	05/09/2014​	2​	3​
12​	Tauranga	05/09/2014​	2​	3​
13​	Tauranga	05/09/2014​	3​	11​
14​	Tauranga	05/09/2014​	3​	11​
15​	Tauranga	05/09/2014​	3​	11​
16​	Tauranga	05/09/2014​	3​	11​
17​	Tauranga	05/09/2014​	3​	11​
18​	Tauranga	05/09/2014​	3​	11​
19​	Tauranga	05/09/2014​	3​	11​
20​	Tauranga	05/09/2014​	3​	11​
21​	Tauranga	05/09/2014​	3​	11​
22​	Tauranga	05/09/2014​	3​	11​
23​	Tauranga	05/09/2014​	3​	11​
24​	Ellerslie	06/09/2014​	1​	21​
25​	Ellerslie	06/09/2014​	1​	21​
26​	Ellerslie	06/09/2014​	1​	21​
27​	Ellerslie	06/09/2014​	1​	21​

 

[Sunline]

Thank you shg , i tested it over 1050 races and it works perfectly . Looking good for test over 32,500 races later .
Thanks again .

 

[shg]

You're welcome, but a pivot table would be way more compact and faster:

	G​	H​
1​	Row Labels	Count of R#
2​	Ellerslie	21​
3​	**06/09/2014	21​
4​	****1	21​
5​	Riccarton Park	53​
6​	**06/09/2014	53​
7​	****1	7​
8​	****2	9​
9​	****3	14​
10​	****4	5​
11​	****5	11​
12​	****6	7​
13​	Tauranga	22​
14​	**05/09/2014	22​
15​	****1	8​
16​	****2	3​
17​	****3	11​

What appear as asterisks above are actually just indents in Excel.