Excel: Array Formula Sum lookup of one list to another

خرید بک لینک

I'm trying to find the total cost of a strategy by looking up the elements that make up that strategy from a table of unique item id's matched to development cost. If an item is in the strategy twice I only want to count the cost once. So strategy 1 would be the cost of Name 1, Name 5, Name 12 and Name 14.

I've played around with this for ages trying various combinations of index match, lookup, and sumif but haven't quite cracked it.

enter image description here

Recent Questions...

ما را در سایت Recent Questions دنبال می‌کنید

برچسب: نویسنده: استخدام کار بازدید: 362 تاريخ: دوشنبه 18 مرداد 1395 ساعت: 17:36

صفحه بندی