Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
add up sums in column m if column c = scott
=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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
add up sums in column m if column c = scott
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 "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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
add up sums in column m if column c = scott
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
=sum(A:A) add to column (B) and new value repeats w/ new sums | Excel Worksheet Functions | |||
Help With A Formula That Sums Items In A Column | Excel Discussion (Misc queries) | |||
How to add previous sums in a column to current sums in a column? | Excel Worksheet Functions | |||
Moving Column Sums to Rows | Excel Discussion (Misc queries) | |||
How can I copy column sums to another spreadsheets as numbers | Excel Worksheet Functions |