I have countries and in which continet they belong in different cells. Then I also have the name of a country and a number of top schools in every country in different cells. I have to find out how many top schools are in every continent. What formula should I use?
Country Continent...
I have a sheet where there is from E17 to E32:
12345--
12345-7
12345-7
1-345-7
1234567
123456-
12345-7
1234567
12345--
12345-7
123--6-
12345--
123456-
123-56-
1234567
1234---
And now I have to figure out how many time each number appears.
Numbers from 1 to 7 are in A4:A10...