Countif total and percentage

I am trying to use countif to count how many nationally ranked schools are in each state. That is column C in sheet 3. I am also trying to use data from collumn B sheet 1 to fill in column D of sheet 3. (in doing so I am trying to find the total number of colleges in each state.) Ultimately I am going to find the percentage of how many nationally ranked teams are in each state. Can anybody give me some pointers?


Attached is the Spreadsheet