Results 1 to 3 of 3
  1. #1
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post

    Select and Sum (Office 97)

    Hi All

    I would like to be able to sum a column based on the text in the adjacent cell. I have attached a sample worksheet

    Thanks in advance
    Attached Files Attached Files
    If you are a fool at forty, you will always be a fool

  2. #2
    Platinum Lounger
    Join Date
    Jan 2001
    Posts
    3,788
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Select and Sum (Office 97)

    In your example, to sum the first set of numbers use

    =SUMIF(C511,"Sales",D511)

  3. #3
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post

    Re: Select and Sum (Office 97)

    Hi Tony

    Thank's very much for your help, I would just like to say to all loungers how refreshing it is in this day and age that there are such fine people as yourselves that are willing to help novices like myself.
    Thank's again
    Braddy77
    If you are a fool at forty, you will always be a fool

Posting Permissions

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