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...
Thanks for your help! Still cant get it right.
This is the full sheet:
Number of flights per weekdays:
1 Monday ?
2 Tuesday ?
3 Wednesday ?
4 Thursday ?
5 Friday ?
6 Saturday ?
7 Sunday ?
Flight Destination Departure Arrival Weekdays
OV 121 Stockholm 07:30 07:30 12345--...
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...