Excel - Sum the quantity of unique items in a table

0
votes

I have the following format for my data. The bolded items on the left are what I am trying to make, items in column C are the materials needed, and column B are the quantity of that material. In column G I have a unique list of items which I want to correspond to their total quantities in column F.

Techniques I've already tried that didn't work:

  • VLOOKUP
  • SUMIF
  • SUM
  • IF
  • COUNTIF
  • Pivot Table

  • Combination of all of the above.

    I've already stumped two of my Business major friends and I've watched a dozen tutorials which are way simpler than what I'm trying to do here.

enter image description here

1
excelsum
Are you trying to find how many Arcanite Bars you have in B and C, our how many Force Reactive Disks you can male with the quantities in column F? If it is the second, do you want to take into account the other items you want to make? – Wyatt Shipman
Sorry, let me be super clear. In this game, I want to craft all those items, so I am taking note of the total amount of supplies I will need for everything. I want to go and total up the materials I need via column F and G. G would correspond to the material name and F corresponds to the total quantity that I will need. – Hatefiend
Further example – Hatefiend

1 Answers

2
votes

Try this

=SUMIF(C:C;"="&$G2;B:B)

enter image description here

EDIT based on Wyatt Shipman comment

=SUMIF(C:C;$G2;B:B)