summing by text in another column
 

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?

summing by text in another column
 

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?

summing by text in another column
 

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?

summing by text in another column
 

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?

summing by text in another column
 

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?

summing by text in another column
 

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?