Results 1 to 5 of 5

Thread: Summing (2007)

  1. #1
    New Lounger
    Join Date
    Jun 2007
    Posts
    19
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Summing (2007)

    Hi, The attached file shows a number of different products that I would like to be able to sum by product quickly, however as the lines are all different is it possible to sum the total however using something like the sumif function to include all criteria however omitting a number of specified criteria?? say sum all but not *SAWN* and *MDF* etc..

    Thanks
    bk
    Attached Files Attached Files

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

    Re: Summing (2007)

    Er, what exactly would you like to sum? I see only a column with product names.

  3. #3
    3 Star Lounger
    Join Date
    Nov 2002
    Location
    New York, New York, USA
    Posts
    266
    Thanks
    0
    Thanked 19 Times in 19 Posts

    Re: Summing (2007)

    Have you considered a Pivot Table based on the data? Once the PT is created you can modify it any way you desire to include or exclude products using the Drop down boxes in the PT. Every time you exclude a product the PT automatically updates and shows new totals. Plus it will do a great job a tquickly grouping you data by Products.

    Regards,

    Tom Duthe

  4. #4
    New Lounger
    Join Date
    Jun 2007
    Posts
    19
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Summing (2007)

    Thanks Hans

    Exactly, there are prices also but i tried to keep it brief. As i mentioned earlier I would like to be able to sum the total of the range but at the same time omitting specified products within the range.. This list is only a very small proprotion of the actual data I have however but to be able to do this funstion if possible would be great..

    thanks for your help
    bk

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

    Re: Summing (2007)

    I'd try Tom Duthie's suggestion of a pivot table.

    If that doesn't work for you, please provide a somewhat more representative workbook so that we can try out things.

Posting Permissions

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