add up sums in column m if column c = scott

[sherri]

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.

 

[Bob Phillips]

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

 

[FSt1]

hi
set up a small table with all your team members names. say column e1 to e5
for 5 team members. then next to the name in column f, enter
=sumfi(b1:B500,e1,c1:C500)
where b is the column with the name, c is the column with the values, and e1
is the cell with the name. copy the formula down the name table. you would
need a formula for each team member name.
make adjustment for your data.
look up the sumif function in help for more details.

Regards
FSt1

 

[Shane Devenshire]

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