I have 2 sheets. in Sheet2 i have my list of items with associated variables (e.g. weight) and in sheet 1 I have a list of bags which contain the items. Any bag can have any amount of items up to 6. I want a formule that irrespective of the amount of items i have in the bag will add up the related variables. So in cell O6 of my workbook in sheet1 I want the the weights of all the items in it. So the weight of the 3 flashlights, 2 paddings and 1 screw. I want this to be done for each variable and importantly I want #N/A to never show.
Currently I`m using this but it is insane to arrange and fix (and I even broke it). I want something a bit less brain damaging
Bookmarks