Hi,

It's not clear what you are summing but this might be it

=SUMIF(C$1:C$100,A1,M$1:M$100)

Where A1 contains the name of the team member who you want to sum the items
in collumn M.

If this helps, please click the Yes button

Cheers,
Shane Devenshire

"sherri" wrote:

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.