Results 1 to 9 of 9
  1. #1
    New Lounger
    Join Date
    Sep 2009
    Location
    Western Australia
    Posts
    6
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hi, I need some help with the following Problem i have, in the attached spreadsheet i have names of people who have carted a certain amount of product and i need to add the totals by name. Bearing in mind that they cart a total of 3 different products.
    Results need to be in columns "L" onwards

    Thanks:Peter
    Attached Files Attached Files

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    Do you want the totals by name by product, or just by name?

  3. #3
    New Lounger
    Join Date
    Sep 2009
    Location
    Western Australia
    Posts
    6
    Thanks
    0
    Thanked 0 Times in 0 Posts
    [quote name='HansV' post='796173' date='03-Oct-2009 06:16']Do you want the totals by name by product, or just by name?[/quote]

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    Peter, your reply only quotes mine, without adding anything...

  5. #5
    New Lounger
    Join Date
    Sep 2009
    Location
    Western Australia
    Posts
    6
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hans, I need to be able to add:

    how much Illnemite Bill has carted,
    how much HiTi Bill has carted,
    how much Other Bill has carted,
    how much Illnemite Harry has carted,
    how much HiTi Harry has carted,
    how much Other Harry has carted,

    Thanks:Peter

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    You could use a pivot table based on the range B13:J18, with Name in the Row area and Illmenite, HiTi and Other in the Data area.
    When the data have changed, click anywhere in the pivot table then click the Refresh button to update the pivot table.

    Alternatively, you could use SUMIF formulas.

    I have created examples of both approaches in the attached version.

    [attachment=85796:Ship_Loading.xls]
    Attached Files Attached Files

  7. #7
    New Lounger
    Join Date
    Sep 2009
    Location
    Western Australia
    Posts
    6
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Thanks Hans

    Do you know of a good web site that explains different formulas and is easy to understand, as i am relativey new at excel?

    Peter

  8. #8
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    This Google Search will return many formula tutorials. Look through them until you find one (or several) that suits you.

  9. #9
    Lounger
    Join Date
    May 2007
    Location
    desertland, Western Australia, Australia
    Posts
    33
    Thanks
    1
    Thanked 0 Times in 0 Posts
    Pete: recognised your name from camp in Paraburdoo...
    at_a2de@hotmail.com (long haired mate of Robs)
    kio

Posting Permissions

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