Total

[Matt in AZ]

I have a 2 columns. Column A has a numbers. Column B has names. I want to total the sum of all the numbers associated with a name and display that in a chart in another cell. What is the formula to use here?

COLUMN A COLUMN B CHART TOTAL
1 Bob Bob 9
5 Bob Tom 10
6 Tom
3 Bob
4 Tom

 

[Domenic]

Hi Matt,

Assuming:

C1=Bob
C2=Tom

Put this formula in D1 and copy it to your other cell or cells:

=SUMIF($B$1:$B$5,C1,$A$1:$A$5)

Hope this helps!

 

[{*BoB*} OZZIE]

Matt - you should be able to get what you are after by
using the sumif formula.

if c2 = bob, then the formula in d2 is
=SUMIF($B$2:$B$6,C2,$A$2:$A$6)

if c3 = tom, then the formula in d3 is
=SUMIF($B$2:$B$6,C3,$A$2:$A$6)"


with data in A2 thru B6.

-----Original Message-----
I have a 2 columns. Column A has a numbers. Column B

has names. I want to total the sum of all the numbers
associated with a name and display that in a chart in
another cell. What is the formula to use here?

 

[Frank Kabel]

Hi
if you don't want a formula solution you may also take a look at pivot
tables for creating this kind of report. See:
http://www.cpearson.com/excel/pivots.htm
http://peltiertech.com/Excel/Pivots/pivotstart.htm
http://www.contextures.com/xlPivot02.html
http://www.ozgrid.com/Excel/excel-pivot-tables.htm