Have had a lot of help in the past hope someone can help me again.
What I have is a table with various headings the ones that I'm concerned about are the assists.
I need to find out how many assits player x has - at the moment i'm using an auto filter to filter out player x in the first column (H) and counting them manually and then doing an auto filter for player x in column (I) counting them and then adding the two together.
Not the ideal situation - could do with a formula that can tell me that in the two columns player x appears x amount of times.
What I have is a table with various headings the ones that I'm concerned about are the assists.
I need to find out how many assits player x has - at the moment i'm using an auto filter to filter out player x in the first column (H) and counting them manually and then doing an auto filter for player x in column (I) counting them and then adding the two together.
Not the ideal situation - could do with a formula that can tell me that in the two columns player x appears x amount of times.
Goals.xls | |||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | |||
1 | Date | Comp | Home | Away | Goal | Assist | Assist | Time | Type | ||||
2 | 06/09/08 | CC | Basingstoke | 1 | 0 | Coventry | BradCruikshank | EricBraff | GregChambers | 2.39 | EH | ||
3 | 06/09/08 | CC | Basingstoke | 1 | 1 | Coventry | ScottKelman | AdamCalder | JonathanWeaver | 20.28 | PP | ||
4 | 06/09/08 | CC | Basingstoke | 1 | 2 | Coventry | SylvainDeschatelets | DanCarlson | AdamCalder | 21.17 | EH | ||
5 | 06/09/08 | CC | Basingstoke | 1 | 3 | Coventry | JonathanWeaver | DanCarlson | ScottKelman | 27.58 | PP | ||
6 | 06/09/08 | CC | Basingstoke | 1 | 4 | Coventry | BarrieMoore | JonathanWeaver | CarlyleLewis | 29.21 | PP | ||
7 | 06/09/08 | CC | Basingstoke | 2 | 4 | Coventry | BradCruikshank | BrentHughes | GregChambers | 32.52 | EH | ||
8 | 06/09/08 | LEA | Hull | 0 | 1 | Manchester | DavidBeauregard | NathanWard | TonyHand | 0.24 | EH | ||
9 | 06/09/08 | LEA | Hull | 0 | 2 | Manchester | AlexDunn | KyleBruce | JoshGarbutt | 12.18 | SH | ||
10 | 06/09/08 | LEA | Hull | 0 | 3 | Manchester | AdamWalker | LukeBoothroyd | 12.44 | SH | |||
11 | 06/09/08 | LEA | Hull | 1 | 3 | Manchester | JeffGlowa | PavelGomenyuk | 14.02 | EH | |||
12 | 06/09/08 | LEA | Hull | 2 | 3 | Manchester | RichardKozak | 29.07 | PP | ||||
13 | 06/09/08 | LEA | Hull | 3 | 3 | Manchester | SlavaKoulikov | MatthewReynolds | JasonKostadine | 32.47 | EH | ||
14 | 06/09/08 | LEA | Hull | 3 | 4 | Manchester | DavidBeauregard | JoshGarbutt | 46.18 | PP | |||
15 | 06/09/08 | LEA | Belfast | 1 | 0 | Cardiff | AndrewMartin | MichaelBurgoyne | PaulDeniset | 11.42 | SH | ||
16 | 06/09/08 | LEA | Belfast | 1 | 1 | Cardiff | MikePrpich | JasonSilverthorn | WesJarvis | 19.12 | EH | ||
17 | 06/09/08 | LEA | Belfast | 1 | 2 | Cardiff | JasonSilverthorn | BradVoth | MichaelHartwick | 19.43 | EH | ||
18 | 06/09/08 | LEA | Belfast | 2 | 2 | Cardiff | AndrewMartin | BobbyRobins | PaulDeniset | 36.39 | EH | ||
19 | 06/09/08 | LEA | Belfast | 3 | 2 | Cardiff | AndrewMartin | BobbyRobins | MichaelBurgoyne | 41.34 | PP | ||
20 | 06/09/08 | LEA | Belfast | 3 | 3 | Cardiff | BradVoth | WesJarvis | PhilHill | 43.16 | EH | ||
21 | 06/09/08 | LEA | Belfast | 4 | 3 | Cardiff | BobbyRobins | PaulDeniset | ShaneJohnson | 52.00 | EH | ||
22 | 06/09/08 | LEA | Belfast | 5 | 3 | Cardiff | BobbyRobins | AndrewMartin | GraemeWalton | 52.46 | EH | ||
23 | 06/09/08 | LEA | Newcastle | 0 | 1 | Nottingham | KevinBergin | JohanMolin | CoreyNeilson | 14.52 | PP | ||
24 | 06/09/08 | LEA | Newcastle | 1 | 1 | Nottingham | WarrenTait | BenCampbell | 30.26 | EH | |||
25 | 06/09/08 | LEA | Newcastle | 1 | 2 | Nottingham | MattMyers | RobertLachowicz | BrendanCook | 44.24 | EH | ||
26 | 06/09/08 | LEA | Newcastle | 2 | 2 | Nottingham | DerekCampbell | RobWilson | MarkGouett | 51.40 | PP | ||
27 | 06/09/08 | LEA | Newcastle | 2 | 3 | Nottingham | DavidClarke | JohanMolin | BruceRichardson | 55.14 | PP | ||
28 | 06/09/08 | LEA | Sheffield | 0 | 1 | Edinburgh | TaylorChristie | ShawnGermain | 5.35 | EH | |||
29 | 06/09/08 | LEA | Sheffield | 0 | 2 | Edinburgh | DougChristiansen | AdamStefishen | TaylorChristie | 8.44 | PP | ||
30 | 06/09/08 | LEA | Sheffield | 0 | 3 | Edinburgh | DougChristiansen | AndrejRajcak | TaylorChristie | 29.19 | PP | ||
31 | 06/09/08 | LEA | Sheffield | 1 | 3 | Edinburgh | JeffLegue | RodSarich | RobertDowd | 52.26 | EH | ||
Scoring (3) |