It may be that the Department names have spaces or non-breaking spaces at
either end which is making the COUNTIF() fail to match some of the data.
Try:

=COUNTIF(A1:A100,"*Department Name*")

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Stacie" wrote in message
...
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!