Hi All,
Been searching to no avail in the below example. Cells B6:G6 are the six drawn numbers with a bonus number in cell H6.
Picked numbers are in cells B11:G15. If you look at cells B15:G16 you'll notice there is 2 picked numbers with a bonus number. The table in cells J3:K8 should indicate there should be a $5 payout. I need the formula modifed in cells H11:H15 to show that there are 2 + bonus that it will reflect the table.
Thanks in advance
Paul
Been searching to no avail in the below example. Cells B6:G6 are the six drawn numbers with a bonus number in cell H6.
Picked numbers are in cells B11:G15. If you look at cells B15:G16 you'll notice there is 2 picked numbers with a bonus number. The table in cells J3:K8 should indicate there should be a $5 payout. I need the formula modifed in cells H11:H15 to show that there are 2 + bonus that it will reflect the table.
Thanks in advance
Paul
Lotto649 Super7.xls | |||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | |||
1 | wednov9 | ||||||||||||
2 | Tickets | Amounts | |||||||||||
3 | 2 + bonus | 5 | |||||||||||
4 | 3 | 10 | |||||||||||
5 | DrawDate | one | two | three | four | five | six | bonus | 4 | 74.7 | |||
6 | Wed Nov 9, 2005 | 4 | 30 | 39 | 42 | 45 | 46 | 38 | 5 | 2397.1 | |||
7 | 5 + bonus | 255354.9 | |||||||||||
8 | 6 | 16840173 | |||||||||||
9 | |||||||||||||
10 | DrawDate | one | two | three | four | five | six | Numbers Drawn | Winnings | ||||
11 | Wed Nov 9, 2005 | 2 | 5 | 17 | 21 | 33 | 36 | 0 | #N/A | ||||
12 | Wed Nov 9, 2005 | 2 | 7 | 8 | 38 | 44 | 46 | 2 | #N/A | ||||
13 | Wed Nov 9, 2005 | 2 | 10 | 22 | 41 | 45 | 49 | 1 | #N/A | ||||
14 | Wed Nov 9, 2005 | 8 | 12 | 16 | 27 | 28 | 44 | 0 | #N/A | ||||
15 | Wed Nov 9, 2005 | 38 | 35 | 42 | 44 | 46 | 49 | 3 | 10 | ||||
Sheet1 |