Hi
I'm after a bit of help please...
I'm compiling football stats for my team, and I'm a bit stuck! I have my sheet laid out similar to the table below.
In the overall appears column, I'm trying to add up the 3 apps columns using a formula to return what I've typed in the Target column.
Can someone please help me do this? I have tried building a formula but I am getting a whole bunch of errors depending which column I try working first.
<tbody>
</tbody>
Many thanks
Gareth
I'm after a bit of help please...
I'm compiling football stats for my team, and I'm a bit stuck! I have my sheet laid out similar to the table below.
In the overall appears column, I'm trying to add up the 3 apps columns using a formula to return what I've typed in the Target column.
Can someone please help me do this? I have tried building a formula but I am getting a whole bunch of errors depending which column I try working first.
Player | League Apps | Cup 1 Apps | Cup 2 Apps | Overall Apps | Target |
A | 9 | 1 | 3 | 13 | |
B | 11 (2) | 1 | 12 (2) | ||
C | |||||
D | (2) | (2) | |||
E | 15 | 3 | 2 | 20 |
<tbody>
</tbody>
Many thanks
Gareth