I’m making a chart to track how many resources I need to collect in order to enhance the armors in The Legend of Zelda: Tears of the Kingdom. However, I am completely stuck on automating the formula for calculating the total amount of each resource needed across all armor sets that have not yet been enhanced.
Legend of Zelda Tears of the Kingdom Armor Enhancement Chart
In the above linked image, we see the spreadsheet in question. Down the left side, we see ingredients listed. Along the right, we see each armor set at each level, and which armor slot has been enhanced in this set per each level. Enhancement starts at level 0 and maxes out at level 4. Armor comes in three slots: Head, torso, and legs. Note that not all armor sets have equipment for each slot. The row of X marks indicate whether a piece of armor has been enhanced to that level yet. For most armor sets, the same exact ingredients are required for each equipment slot at a given level; therefore it was redundant to not merge the cells in these cases. The “Total” column should list how many of each ingredient is still required across all armor set levels to which have not been enhanced.
The problem is that I don’t know what I would be looking for to slot in the formula that would perform these calculations. Basically, if there isn’t an X in a slot in the row above, the Total column should be counting the quantity values per each ingredient for that armor set level. This tells the player how many of an item they need to acquire. Because there are NN-B columns, going through each and every column is not the computer way to solve this issue, and only results in more work. I don’t have an idea what function command I’m looking for, so I don’t even know what it is that I need to look up on site.