Results 1 to 6 of 6
  1. #1
    New Lounger
    Join Date
    Apr 2002
    Location
    Dallas, Texas, USA
    Posts
    17
    Thanks
    0
    Thanked 0 Times in 0 Posts
    How can I sum up the total of dollars for each instance of an item using VLookup?

    I have a table that contains items as rows

    Carrots
    Peas
    Onions

    On the main sheet I need totals of every instance of price for each of the fields on the main sheet. Example, if on the second sheet I have 20 instances of Carrotts for $1.oo each, I need it to locate all of them and calculate the total as $20.00.

    How do I do this?

  2. #2
    Silver Lounger
    Join Date
    Jul 2001
    Location
    Ottawa, Ontario, Canada
    Posts
    1,609
    Thanks
    0
    Thanked 1 Time in 1 Post
    [quote name='rgunsta' post='793784' date='17-Sep-2009 16:32']How can I sum up the total of dollars for each instance of an item using VLookup?

    I have a table that contains items as rows

    Carrots
    Peas
    Onions

    On the main sheet I need totals of every instance of price for each of the fields on the main sheet. Example, if on the second sheet I have 20 instances of Carrotts for $1.oo each, I need it to locate all of them and calculate the total as $20.00.

    How do I do this?[/quote]
    Try using the SUMIF function as shown in the attached file.
    Attached Files Attached Files
    Regards
    Don

  3. #3
    Plutonium Lounger
    Join Date
    Nov 2001
    Posts
    10,550
    Thanks
    0
    Thanked 7 Times in 7 Posts
    You could also use a pivot table for this, but you need to right click the table and choose refresh when the data changes. See attached example.

    [attachment=85567:PivotTable.xls]
    Attached Files Attached Files

  4. #4
    New Lounger
    Join Date
    Apr 2002
    Location
    Dallas, Texas, USA
    Posts
    17
    Thanks
    0
    Thanked 0 Times in 0 Posts
    [quote name='wdwells' post='793787' date='17-Sep-2009 15:46']Try using the SUMIF function as shown in the attached file.[/quote]


    Thanks!! That worked perfectly!

  5. #5
    3 Star Lounger
    Join Date
    May 2008
    Location
    India
    Posts
    306
    Thanks
    0
    Thanked 0 Times in 0 Posts
    [quote name='wdwells' post='793787' date='18-Sep-2009 02:16']Try using the SUMIF function as shown in the attached file.[/quote]
    Is there any specific reason to put "=" sign in criteria? As per my understanding, results can be derived without putting it. Pls correct me.
    Regards
    Prasad

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    The formulas will work with "Carrots" and with "=Carrots" etc. The result is the same.

Posting Permissions

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