View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
FSt1 FSt1 is offline
external usenet poster
 
Posts: 3,942
Default 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?