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?
|