Total

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Matt in AZ (MattinAZ_at_discussions.microsoft.com)
Date: 06/11/04 

Date: Fri, 11 Jun 2004 16:29:02 -0700

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 

-- 
Matt in AZ

Relevant Pages

  • Re: SUM, AVERAGE and PRINT with #N/A cells
    ... brings results from another worksheet once I get some data for that month. ... So what I really want is to get in my chart just the values I have and not ... So in effect we are saying that sum all numbers which are less than or equal ... cell) but when I print my page, I get the #N/A in black (so I can see ...
    (microsoft.public.excel.worksheet.functions)
  • RE: Sum or Average with #N/A cells
    ... Thanks Sheeloo, but the problem with this formula is that I get the chart ... cell is for example in gray I get the #N/A in black) and not to appear a line ... How may I get the SUM or the AVERAGE for that column and how may I print my ...
    (microsoft.public.excel.worksheet.functions)
  • Filling in a chart from a list
    ... I know that a pivot table would be ideal. ... So what I am trying to do is something like a sum of vlookups. ... this cell has this value, add its value from another cell in the same ... I would do that for each cell in the chart. ...
    (microsoft.public.excel.programming)
  • Re: Total
    ... Put this formula in D1 and copy it to your other cell or cells: ... > total the sum of all the numbers associated with a name and display that in a ... > chart in another cell. ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Table Formula =SUM(ABOVE) give incorrect result when there is
    ... whenever there is only one row to sum in ANY part. ... to sum the columns above the merged cell. ... This template always work correctly for me except in cases when there is ... Below each Part there is a row for Sub Total Part-X, ...
    (microsoft.public.word.tables)