Stacie,

Posting you formula would be a good start but on the assumption the formula
is correct the usual suspects are rogue spaces and numbers that look like
numbers but are in fact text and I'm always particularly suspicious when the
data are pasted.

So check you department column for rougue spaces and verify you numbers
coulumn with

=isnumber(a1)

which will return TRUE for a number or FALSE for text.

Mike

"Stacie" wrote:

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!