=COUNTIF(C:C,"team member")

--
__________________________________
HTH

Bob

"sherri" wrote in message
...
I have a spreadsheet where I am putting different team members in column c
if
they are the ones that are assigned to that particular policy and then I
need
the entire worksheet added up by team member...so I need to create an 'if"
sum that if column c equals team member "x's name" then total all those
lines
and if column c equals team member "y's name" then total all those
lines...i
am not sure how to set this up.