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?