Total

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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!
 
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
Click to expand...
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?
 
Back
Top