Results 1 to 6 of 6
  1. #1
    New Lounger
    Join Date
    May 2005
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Special Sum formula needed (Excel 2003)

    I am looking for a formula.................e.g. in column C there are letters of the alphabet (a,b,c,d) labels - in column G are totals (values). I need a formula that will take ALL the a's from column C and add ALL the dollar amounts from column g that correspond with the a's. This total will be in one cell.

    Please advise

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Special Sum formula needed (Excel 2003)

    Welcome to Woody's Lounge!

    Try this formula:

    <code>=SUMIF(C1:C100,"a",G1:G100)</code>

    You can change the ranges to include more or fewer rows.

  3. #3
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Special Sum formula needed (Excel 2003)

    Just my <img src=/S/2cents.gif border=0 alt=2cents width=15 height=15> if you are not aware if the feature! After you sort the labels in the C coloumn, you can active the subtotals feature in the Data menu. This will give you totals for All the labels.
    Also, what could be useful is to use DSUM. If you search this forum for examples you will find plenty to go by.
    Regards,
    Rudi

  4. #4
    Star Lounger
    Join Date
    Feb 2003
    Posts
    89
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Special Sum formula needed (Excel 2003)

    How about a Pivot Table.

  5. #5
    New Lounger
    Join Date
    May 2005
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Special Sum formula needed (Excel 2003)

    Where could I get more information about Pivot Tables. I do not understand how it would work.

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Special Sum formula needed (Excel 2003)

    The built-in help for Excel provides some information, and here is a tutorial on the Microsoft website: Microsoft Office Assistance: PivotTable reports 101 (you can expand the steps to see details).

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •