Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Can I sum numbers in one column based on the name in another column? So if
Bubba is listed 5 times with 5 different numbers (commissions) in a different column, how do I add those as well as 20 other people's commissions by their names? |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
hi
names in column A commissions in column B =sumif(A1:A100,"Bubba",B2:B100) adjust ranges to suit. Regards FSt1 "schmas" wrote: Can I sum numbers in one column based on the name in another column? So if Bubba is listed 5 times with 5 different numbers (commissions) in a different column, how do I add those as well as 20 other people's commissions by their names? |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi
Something like this =SUMIF(A1:A207,"Bubba",B1:B20) HTH John "schmas" wrote in message ... Can I sum numbers in one column based on the name in another column? So if Bubba is listed 5 times with 5 different numbers (commissions) in a different column, how do I add those as well as 20 other people's commissions by their names? |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Simplest way is to use sumif command. suppose names are in column A and
numbers(commissions) are in column B. The syntax for sumif is as follows: sumif(range,criteria,sum_range) For range you have to address column A (names) For criteria you have to specify a name you are trying to sum, like "Bubba " For sum_range you have to specify column B (numbers you want to sum up) For criteria, you can either specify the name by typing it enclosing inside "" or you can type the address of cell which contains the name. Excel 2003 and higher ver have a wizard which guides you through steps to perform conditional su.m it is under Tools/Conditional sum. Hope this helps "schmas" wrote: Can I sum numbers in one column based on the name in another column? So if Bubba is listed 5 times with 5 different numbers (commissions) in a different column, how do I add those as well as 20 other people's commissions by their names? |
#5
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
What if I have a bunch of different names in column A and I want a sum for
each name? Is there a fast and easy way or will I have to do the below formula for each name? "FSt1" wrote: hi names in column A commissions in column B =sumif(A1:A100,"Bubba",B2:B100) adjust ranges to suit. Regards FSt1 "schmas" wrote: Can I sum numbers in one column based on the name in another column? So if Bubba is listed 5 times with 5 different numbers (commissions) in a different column, how do I add those as well as 20 other people's commissions by their names? |
#6
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
hi
yes, you would need a sumif for each name should you want a seperate total for each name. you might create a small table with the names with totals for each name. you could then sum the sumif's for a grand total and cross reference the sumif totals to the commissions column total. Regards FSt1 "schmas" wrote: What if I have a bunch of different names in column A and I want a sum for each name? Is there a fast and easy way or will I have to do the below formula for each name? "FSt1" wrote: hi names in column A commissions in column B =sumif(A1:A100,"Bubba",B2:B100) adjust ranges to suit. Regards FSt1 "schmas" wrote: Can I sum numbers in one column based on the name in another column? So if Bubba is listed 5 times with 5 different numbers (commissions) in a different column, how do I add those as well as 20 other people's commissions by their names? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Summing a column based on the length of text in a cell in anothercolumn | Excel Worksheet Functions | |||
need help summing text in column | Excel Worksheet Functions | |||
summing column c based an column a criteria | Excel Worksheet Functions | |||
Summing a Column instead of a Column range | Excel Discussion (Misc queries) | |||
Summing one column based on date in another column | New Users to Excel |