Thread: How To Sum Multiple Items using VLookup with SUM?

1. 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. [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.

3. 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]

4. [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. [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.

6. 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
•