RE: summing by text in another column

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

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

Quantcast