Excel: Football Trnasfer Analysis
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.


kindly advise on how to get data for incoming transfers. tx
7 answers ( 0 marked as helpful)
Hi!
Do you want to use column C of the 'Database' sheet, please?
Best,
Ned
Column C of the database sheet? Am I to use countif per country in Europe to get the number of incoming transfer?
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


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
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
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
Sir, Can't seem to get the right answer even though the formula is correct. Please help!

