This is my first post on this forum so please bear with me.

The problem I have is to do with the UK 649 lottery.

There are several of us in a syndicate, and as all the members in this forum will appreciate, we are always looking for ways to beat the system.

We change our syndicate numbers from time to time, and could do as many as 50 lines.

What I really want to do is test EACH of the syndicates new lines over the complete Lottery history ( at present 765 draws ).

I would like an individual total for each syndicate line for Match 3, Match 4, Match 5, Match 5+ The Bonus and Match 6 ( I wished ).

The sydicate lines are in ( Excel 2002 ) M1:R50 for example.

The history of All the Lottery draws are in ( Excel 2002 ) E1:K765.

The result would look something like this :-

Results Over ALL Draws ( 765 )

Sydicates ---- 3 4 5 5+ 6

Lines ---- Match Match Match Match Match

-----------------------------------------------------------------

1 2 3 4 5 6 ---- 10 4 2 1 0

7 8 9 10 11 12 ---- 15 6 1 0 1

Is this possible using formulas ( Or Several )?, or will it need VB

code.

I am using Excel 2002 ( Windows XP).

Thanks for your help.

Regards

PAB