Ananthak275
Board Regular
- Joined
- Aug 22, 2020
- Messages
- 128
- Office Version
- 2013
- Platform
- Windows
- MacOS
Got a table that starts on B5 and C5. I want to get the following calculations:
i want to calculate the following:
1. Percentage of total overlap of sports played in both Countries, each row gets 1 value is played in both sports, dived by the total number of sports (in this example 5). So this one would be Lacrosse and Soccer which is two sports, hence output would be 2/5 = 40%. Output should be in cell A1. Just the percentage in a1.
2. how many are played ONLY in Latvia. In this example: Basketball and Football so 2/5 = 40%. Output should be in cell B1. Just the percentage in B1.
3. how many are played ONLY in Russia. In this example: Hockey so 1/5 = 10%. Output should be in cell C1. Just the percentage in c1.
Latvia (b5) | Russia (c5) | |
Lacrosse | 2 | 5 |
Hockey | 5 | |
Basketball | 1 | |
Football | 1 | |
Soccer | 1 | 1 |
i want to calculate the following:
1. Percentage of total overlap of sports played in both Countries, each row gets 1 value is played in both sports, dived by the total number of sports (in this example 5). So this one would be Lacrosse and Soccer which is two sports, hence output would be 2/5 = 40%. Output should be in cell A1. Just the percentage in a1.
2. how many are played ONLY in Latvia. In this example: Basketball and Football so 2/5 = 40%. Output should be in cell B1. Just the percentage in B1.
3. how many are played ONLY in Russia. In this example: Hockey so 1/5 = 10%. Output should be in cell C1. Just the percentage in c1.