home_winlay_away (10).csv | |||||||
---|---|---|---|---|---|---|---|
A | B | C | D | E | |||
1 | goal times | desired result | |||||
2 | home | away | home | away | |||
3 | 24 62 | 45 | 2 | 1 | |||
4 | 76 | 48 | 1 | 1 | |||
5 | 30 75 | 49 | 2 | 1 | |||
6 | 48 | 32 35 41 62 | 1 | 4 | |||
7 | 4 19 | 0 | 2 | ||||
8 | 15 61 | 0 | 2 | ||||
9 | 72 | 17 | 1 | 1 | |||
10 | 61 | 30 52 54 | 1 | 3 | |||
11 | 0 | 0 | |||||
12 | 9 32 | 12 51 | 2 | 2 | |||
13 | 8 42 | 3 68 | 2 | 2 | |||
14 | 90 | 1 | 0 | ||||
15 | 45 59 | 67 78 | 2 | 2 | |||
16 | 83 | 0 | 1 | ||||
17 | 19 36 44 | 0 | 3 | ||||
18 | 75 | 35 | 1 | 1 | |||
19 | 52 | 12 | 1 | 1 | |||
Sheet1 |
Hi
Is there a formula that can count the numbers in a cell in order to work out a score? So instead of manually inputting the scores in col D & E a formula would work it out.
Cheers