View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sherri Sherri is offline
external usenet poster
 
Posts: 25
Default add up sums in column m if column c = scott

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.