Excel: Football Trnasfer Analysis

Question

1. i am on step 3 of the FTA project. i calculated the sum of outgoing transfers from europe using SUM IFS but i am yet to see a column for number of incoming transfers cos there is no data for incoming transfers, i have attached a screen shot for your perusal.

I have also screen shot how i got the sum for out going transfers

kindly advise on how to get data for incoming transfers. tx

Answer 1

Hi!

Do you want to use column C of the 'Database' sheet, please?

Best,

Ned

Answer 2

Column C of the database sheet? Am I to use countif per country in Europe to get the number of incoming transfer?

Answer 3

i have calculated the number of incoming and outgoing transfers using

count and sum respectively.

find below a screen shot of the data base sheet showing some cells as zero , it also showed that its total club compensation, i have gone through the review again so as to derive a formula for the compensation, i dont think the info on the club compensation is complete, kindly advise

Answer 4

Hello Ned,

you are yet to answer my question, i thought of getting an averge transfer fee using the number of incoming and outgoing players per country . the issue is that it will give an average, and the guide is asking for incoming and outgoing transfer fee.

i have reviewed the notes, i am yet to see an information that will help in deriving a formula, kindly advise

Answer 5

Hey Abiola,

Here's the formula I've used to calculate incoming transfers:

And here's the formula for outgoing:

Then i have the following per country:

And here's the dollar amount:

Hope this helps!

Best,

Ned

Answer 6

Hello Ned, i tried submitting my project but i realised a screen shot would not suffice, hence using this link

1. Country transfer analysis: https://1drv.ms/x/c/fb2b261b33bb81c9/EYs7RnydvzBMmMUasR3w-UwBtNgoKbd4v3BkR6hEFbfi8Q?e=9b4i1C

2, Net transfers : https://1drv.ms/x/c/fb2b261b33bb81c9/EYs7RnydvzBMmMUasR3w-UwBtNgoKbd4v3BkR6hEFbfi8Q?e=u4eLct

3. top 5 European transfer fees :https://1drv.ms/x/c/fb2b261b33bb81c9/EYs7RnydvzBMmMUasR3w-UwBtNgoKbd4v3BkR6hEFbfi8Q?e=Ud8pjD

if there is abetter way of submitting my work, kinldy advise

Thank you

Answer 7

Sir, Can't seem to get the right answer even though the formula is correct. Please help!

Answer 8

Every time I visit liobet predictions on BestFootballPrediction.com, I walk away with a clearer understanding of the upcoming fixtures. They provide a perspective that goes beyond simple statistics, focusing on strategy and context that really influence the outcome of games. For me, it has become a source of learning as much as a source of guidance. I particularly enjoy the way they break down team formations and individual player impact. It feels like I’m constantly improving my football knowledge, which makes following matches even more exciting and rewarding.

Excel: Football Trnasfer Analysis

Submit an answer

related questions