sum data in column B based on values in column A

[iggator2003]

How can I sum data from column B based on the values in column A being the same?

Example:
Column A Column B Column C
George 1
George 2
George 2 5
Jeff 3
Jeff 1
Jeff 4 8

Column C is summing the values in column B based on the values in column A being the same.

 

[Joe4]

Take a look at the SUMIF formula.
Excel's built-in help files have detailed descriptions and examples of how to use this function.

 

[iggator2003]

Thanks, but the sumif or sumifs doesn't seem to be working. Isn't there a way to do an array formula to get what I'm looking for?

 

[Joe4]

SUMIF will work, you may just be having a problem with the formula.
If your data is in range A2:B7 (like in your example), place this formula in cell C2 and copy down for all rows:
=IF(A2<>A3,SUMIF(A$2:A$7,A2,B$2:B$7),"")

The IF part of it is just used to return nothing unless it is the last row for a name (so it only shows the total in the last row).

Other options include using Subtotals or Pivot Tables.

 

[T. Valko]

Thanks, but the sumif or sumifs doesn't seem to be working. Isn't there a way to do an array formula to get what I'm looking for?

Based on your sample data, if an array formula will work then so should SUMIF.

Can you be more specific about what "doesn't seem to be working" means?

Are you getting some kind of error? Incorrect result?