GreganDunn
New Member
- Joined
- Jan 7, 2017
- Messages
- 12
I'm pretty sure that SUMPRODUCT is the solution to my problem here. I'm new to the SUMPRODUCT formula and fully understand it's basics and straight forward usage, however my SUMPRODUCT usage/requirement is a little more complex are I'm struggling with finding the right syntax to make things work for me.
I'm attempting to create a new data set that lists the FRAGMENTS (or components) needed for a given UPGRADE based on the ITEM (items are composed of fragments) requirements for an upgrade and the RECIPE of the FRAGMENTS to create an ITEM.
I have an insane spreadsheet to plug this into, but I've narrowed it down and simplified it to the attached spreadsheet. The whole vertical/horizontal array thing is screwing me up in my specific example.
Thanks for taking the time to have a peak at my challenge, I really appreciate it!
Example File: https://www.dropbox.com/s/rqwq372hs2ome35/Upgrade Item to Fragments.xlsx?dl=0
Screenshot:
I'm attempting to create a new data set that lists the FRAGMENTS (or components) needed for a given UPGRADE based on the ITEM (items are composed of fragments) requirements for an upgrade and the RECIPE of the FRAGMENTS to create an ITEM.
I have an insane spreadsheet to plug this into, but I've narrowed it down and simplified it to the attached spreadsheet. The whole vertical/horizontal array thing is screwing me up in my specific example.
Thanks for taking the time to have a peak at my challenge, I really appreciate it!
Example File: https://www.dropbox.com/s/rqwq372hs2ome35/Upgrade Item to Fragments.xlsx?dl=0
Screenshot:
![Screen%20Shot%202018-07-19%20at%208.31.07%20PM_zpso04qzyb5.png](/board/proxy.php?image=http%3A%2F%2Fi34.photobucket.com%2Falbums%2Fd137%2FGreganDunn%2FScreen%2520Shot%25202018-07-19%2520at%25208.31.07%2520PM_zpso04qzyb5.png&hash=845dfa80e40e2b6de84f2498238b0bd7)
Last edited: