Jockey wins to date. Sumproduct .

[Sunline]

Hello all,

I have this function that PeterSS provided for me .

It does give correct result but only on last entry . The cells in col HK in blue
should be zero .
I hoping to get a small amendment to give me the results I have in col HK .

Col Z should be returning zero if there is no number 1 or 1= in col V .

I have hilghted in red col HK correct results .

Thanks .

Excel Workbook
	F	V	Z	AD	HK
1	Date	Placing	Jwin	Jockey	Result
2	1/08/2013	6	0	Jo Rathbone	0
3	1/08/2013	1	1	Buddy Lammas	1
4	1/08/2013	7	0	Gary Walsh	0
5	1/08/2013	8	0	Shannon Doyle	0
6	1/08/2013	2	0	Charlie Studd	0
7	1/08/2013	5	0	Kayla Veenendaal	0
8	1/08/2013	4	0	Isaac Lupton	0
9	1/08/2013	3	0	Aimee Taylor	0
10	1/08/2013	5	0	Jo Rathbone	0
11	1/08/2013	6	0	Niall Quinn	0
12	1/08/2013	3	1	Buddy Lammas	0
13	1/08/2013	4	0	Rory Hutchings	0
14	1/08/2013	7	0	Shannon Doyle	0
15	1/08/2013	1=	1	Kane Smith	1
16	1/08/2013	2	0	Gary Walsh	0
17	1/08/2013	1	1	Lisa Whelan	1
18	1/08/2013	5	0	David Walker	0
19	1/08/2013	4	1	Buddy Lammas	0
20	1/08/2013	3	0	Hayden Tinsley	0
21	1/08/2013	2	0	Darryl Bradley	0
22	1/08/2013	6	0	Mereana Hudson	0
23	1/08/2013	3	0	Johnathon Parkes	0
24	1/08/2013	6	1	Buddy Lammas	0
25	1/08/2013	4	0	Dylan Turner	0
26	1/08/2013	5	1	Lisa Whelan	0
27	1/08/2013	1	2	Buddy Lammas	2
28	1/08/2013	2	0	Amanda Morgan	0
29	1/08/2013	1	3	Buddy Lammas	3
30	1/08/2013	4	0	Kei Chiong	0
31	1/08/2013	3	0	Rory Hutchings	0
32	1/08/2013	7	0	Hayden Tinsley	0
33	1/08/2013	8	0	Bridget Grylls	0
34	1/08/2013	1	2	Kane Smith	2
Sheet1

 

[MARK858]

Does this help...

Excel Workbook
	F	V	Z	AD	HK
1	Date	Placing	Jwin	Jockey	Result
2	01/08/2013	6	0	Jo Rathbone	0
3	01/08/2013	1	1	Buddy Lammas	1
4	01/08/2013	7	0	Gary Walsh	0
5	01/08/2013	8	0	Shannon Doyle	0
6	01/08/2013	2	0	Charlie Studd	0
7	01/08/2013	5	0	Kayla Veenendaal	0
8	01/08/2013	4	0	Isaac Lupton	0
9	01/08/2013	3	0	Aimee Taylor	0
10	01/08/2013	5	0	Jo Rathbone	0
11	01/08/2013	6	0	Niall Quinn	0
12	01/08/2013	3	0	Buddy Lammas	0
13	01/08/2013	4	0	Rory Hutchings	0
14	01/08/2013	7	0	Shannon Doyle	0
15	01/08/2013	1=	1	Kane Smith	1
16	01/08/2013	2	0	Gary Walsh	0
17	01/08/2013	1	1	Lisa Whelan	1
18	01/08/2013	5	0	David Walker	0
19	01/08/2013	4	0	Buddy Lammas	0
20	01/08/2013	3	0	Hayden Tinsley	0
21	01/08/2013	2	0	Darryl Bradley	0
22	01/08/2013	6	0	Mereana Hudson	0
23	01/08/2013	3	0	Johnathon Parkes	0
24	01/08/2013	6	0	Buddy Lammas	0
25	01/08/2013	4	0	Dylan Turner	0
26	01/08/2013	5	0	Lisa Whelan	0
27	01/08/2013	1	2	Buddy Lammas	2
28	01/08/2013	2	0	Amanda Morgan	0
29	01/08/2013	1	3	Buddy Lammas	3
30	01/08/2013	4	0	Kei Chiong	0
31	01/08/2013	3	0	Rory Hutchings	0
32	01/08/2013	7	0	Hayden Tinsley	0
33	01/08/2013	8	0	Bridget Grylls	0
34	01/08/2013	1	2	Kane Smith	2
Sheet4

 

[Sunline]

Thanks i will try this out.
Thank you .