So I have two columns of data, Department and College.

I am using the countif formula to count how many times a department appears
in the department column, but then when I sum the counts, it doesn't add up
correctly. I am almost positive that everything is spelt right, since I just
copied and pasted. So I am wondering if the formula isn't counting them
right and advice for that or should I be using a different formula. Any help
would be appreciated! Thank you!